Cannot step through entire macro - works to a point then runs rest of commands

[KGee]

I'm getting a macro error in a file that hasn't been modified in nearly a year. I suspect it has something to do with the machine I'm using now which crashes Excel when I select yes to debug the code. So I am trying to manually step through the code using F8 to determine which line it doesn't like but I get to a certain point and then it tries to run the rest of the macro. Any reason why it would do something like this? In the meantime I'm going to put in a number of breakpoints to see if that helps me find the problem. Thanks

 

[jsb1921]

which ever line you think the error is, before that, insert a line
on error goto 0
and debug again. remove the line when you have found out the error.

 

[Peter_SSs]

See it this thread helps, particularly post #4 by RoryA

 

[KGee]

Thanks jsb I was able to figure out which line of code is at fault. I am adding a new workbook and based on the link Peter provided it seems that might be one of the triggers for this step-through behavior. So the line causing the problem is doing an XLPasteFormats. I will open a separate thread for that issue but the strange thing is I have the exact same code in multiple files and it is only crashing in this file.

 

[Peter_SSs]

I am adding a new workbook and based on the link Peter provided it seems that might be one of the triggers for this step-through behavior.

That is exactly the sort of thing that used to be the problem for me stepping through the code. I made the registry change and haven't experienced the run-through behaviour ever again. ?

 

[KGee]

That is exactly the sort of thing that used to be the problem for me stepping through the code. I made the registry change and haven't experienced the run-through behaviour ever again. ?

The Reg is locked down on our machines but I already have a pending request to get admin rights so I'll be able to change it soon...hopefully. Thanks