Code just...stopping for no reason

[roscoe]

I have a rather large and complicated spreadsheet that has developed an odd behavior. It will stop for no reason on the same line of code. A simple F5 command will start it back up again, but I can not for the life of me figure out why. It's acting as though a STOP commas were in the code but there isn't.

Any ideas out there?

 

[jkpieterse]

I bet there used to be a breakpoint on that line. VBA sometimes does not clean up well. Download and run Code Cleaner from www.appspro.com to fix this.

 

[roscoe]

You're probably right. I downloaded the utility, will give it a shot. Thanks