Tag Archives: performance

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

High Speed Blog …

… brought to you via Smurf on Spreadsheets If you want your spreadsheets to go faster, Charles Williams is the man to tell you how to do it.  Charles has recently started a blog on the subject: FastExcel Well worth … Continue reading

Posted in Excel, VBA | Tagged , , | Leave a comment

Excel 2007 performance – Microsoft looking for feedback

The latest post on the Microsoft Excel Blog is asking for comment on slow performance of Excel 2007, specifically related to VBA: Microsoft Excel Blog I encourage everyone to respond!

Posted in Excel, VBA | Tagged , , , | 1 Comment