Tag Archives: Collection

Arrays vs Collections vs Dictionary Objects (and Dictionary help)

A recent comment by Lori Miller at Daily Dose of Excel suggested that (for the particular application being discussed) the VBA Collection object was quicker than using scripting dictionaries.  Since I hardly ever use collections (other than the built-in ones), and … Continue reading

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

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

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