Recent Comments
Compiled AlgLib Matr… on Compiled AlgLib Matrix Functio… 
guddu on Automatic download of csv… 
dougaj4 on Return of Excel – Evalua… 
phix345 on Return of Excel – Evalua… New sort functions a… on A Sort Function 
smartcarrion on 64 bit Excel and PtrSafe dougaj4 on 3DFrame – 3D Frame analy… 
Mark Firkins on 3DFrame – 3D Frame analy… Lennox Bridge | Newt… on Trinity Bridge and Bridge of t… Trunc Function In Ex… on More Numpy with Excel and… dougaj4 on Using LinEst() on data with… 
Charlene on Using LinEst() on data with… dougaj4 on Jaqui Mcshee 
raduga fenerbahce on Jaqui Mcshee 
John on Installing Adobe Reader non-DC…
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 Collection, Excel, performance, Scripting dictionary, VBA
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
