I don't believe a simple for loop wound give yo this problem. I bet if
yo eliminate all the code inside the for loop the problem will stop.
Sub Test
For m = 1 to 26
a = m
next m
msgbox("finished for Loop")
End Sub
I will repeat my tow tips when ever there are unexplained problems
1) Comment out all On Error statements until you isolate the problem
2) Enable trapping on ALL Errors. Go to VBA menu
Tools - Options - General - Error Trapping - break on All errors
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=171606
Microsoft Office Help