Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Contour plots with Excel and Matplotlib
- Fitting high order polynomials
- Latex Maths Text in Excel
- Removing Add-ins
Recent Comments
Jose Luna on More updates to ArcSpline and… Lucas Beattie on Drawing in Excel – … marcengineer on More on combined shear and ben… dougaj4 on More on combined shear and ben… Marc on More on combined shear and ben… Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU
Tag Archives: Array
Writing Arrays to the worksheet – VBA function
Previous posts have looked at the VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible, most recently here. I have now put this code in a function that can be conveniently called from any … Continue reading
The speed of loops
Commenting on the Good Practice post, John Tolle pointed out that with a collection it was very much quicker to loop using a For each loop than iterating by index, using a for, next loop. I did some simple tests on this, … Continue reading
Ranges and Arrays
Transferring data from a worksheet into a VBA routine, or the other way round, is one of the most frequent tasks carried out in VBA programming. Fortunately there is a simple way to do it: In a subroutine: Name the … Continue reading