Excel 2003 VBA Automaticaly Loops

[tbello]

I have written a lengthy macro in Excel 2003, approximately 1,300 lines. The macro has been running without any glitches until today. It now loops to the beginning without being prompted to. If I place an "Exit Sub" a few lines before the end of the macro, it does not loop. I do have a "GoTo" within the macro that goes to the line directly above "End Sub".

 

[texasalynn]

Welcome to MrExcel board...

I would suggest that you step through the macro and see where it might be failing. (goto macros click the one you need and then click on step into then use the F8 key for every line in the macro)

 

[MrKowz]

Welcome to the forums!

Can you please provide the code so we can debug it?

 

[tbello]

Not sure what happened, but I deleted a few lines and the code does not loop anymore - very odd. I am written alot of code but have never seen that.