Speed Up VBA Loop Code

**jolivanes** · 12-29-2012, 05:24 PM

Hi Richard
That is a considerable difference, 15.7 vs 41.5 seconds. My computer is about 6-7 years old so definitely not the latest screaming fast machine.
Happy, Healthy and Prosperous 2013 to you and yours.

John

**Richard Buttrey** · 12-29-2012, 06:49 PM

Yes, odd indeed. Mine is a 2008 vintage Dell Latitude, so a bit long in the tooth perhaps, but still pretty fast. I wondered if there were other apps running but I don't think so and the slow running was consistently on the macro mentioned - and I tried all of them several times.

**jolivanes** · 12-30-2012, 07:20 PM

Hi Richard.
I tried it on my 8 year old laptop (Tecra with 1GB Ram and 1.8 GHz processor) but that has Office 2003 on it so not really a valid comparison.
I saved the file in .xls format and ran the different scenarios on both computers with pretty well identical results on both.
0.83 - 0.78 - 1.97 and 0.80 seconds.
However, because of the less rows in 2003, the range to work on is now only 65,535 cells.