Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Downloads by category
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Rabbits, Foxes, and Lorenz Attractors
- The angle between two vectors, Python version
- Time in hours and minutes between two dates
- Downloads
- Installing Adobe Reader non-DC version.
Recent Comments
Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and… dougaj4 on Deflections and Moments in Rec… Kaushal on Deflections and Moments in Rec… Kurt Clark on Working with units in Excel…
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