Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Contour plots with Excel and Matplotlib
- Stereograms
- Drawing in Excel 7 - Creating drawings from coordinates
- Solving non-linear equations with two or more unknowns – 5
- About Newton Excel Bach
- Installing AlgLib with Excel VBA
Recent Comments
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