Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 5: Frame Analysis
- Automating chart scale limits - update
- Moving averages and User Defined Array Functions
- About Newton Excel Bach
Recent Comments
Tag Archives: Range
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