So, what's the content of A65535?

Suspect you're actually trying to loop for all rows in a sheet.
In which case whatever is in the For/Next loop is slowing things down. Could
you please supply?


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"scain2004 " wrote in message
...
What looping method is the fastest if you have nested loops? I've got
several ( For i = Range("A65536") To 1 Step -1 ) loops that take
forever to run. Any suggestions on how to speed this up?


---
Message posted from http://www.ExcelForum.com/