My guess is you wanted to loop from the last used cell in column A to the first
row:

dim i as long
for i = range("a65536").end(xlup).row to 1 step -1

instead of
For i = Range("A65536").Value To 1 Step -1
or even
For i = 65536 To 1 Step -1





"scain2004 <" wrote:

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/

--

Dave Peterson