Tag Archives: Array

Writing Arrays to the worksheet – VBA function

Posted on March 12, 2012 by dougaj4

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 →

Posted in Arrays, Excel, VBA | Tagged , , , , | 17 Comments

The speed of loops

Posted on March 7, 2010 by dougaj4

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 →

Posted in Arrays, Excel, VBA | Tagged , , , , , | 8 Comments

Ranges and Arrays

Posted on March 4, 2008 by dougaj4

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 →

Posted in Arrays, Excel, UDFs | Tagged , , , | 4 Comments