Home Stuck in infinite loop. Any way to break vba into Code when Control+Break doesn't work
Reply: 0

Stuck in infinite loop. Any way to break vba into Code when Control+Break doesn't work

user832
1#
user832 Published in June 21, 2018, 8:41 am

I have code stuck. It might be in an infinite loop. Not sure.

Is there a way to break the program to stop at the current line of code that it is running on?

I'd like to avoid shutting down excel because I want to be able to catch where in the loop it is, and by going into the code, I will be able to tell how much processing was done. I would like to break into the code, if possible.

It is stuck on hour glass.

Ctrl+Break doesn't seem to work

Seems like the running code has hijacked all the quota that cpu is giving to excel.

If there is nothing I can do now, is there something in the future I can do to where I can more easily break into the code?

I'm thinking that an intermittent wait within a loop might be a feasible solution.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.354829 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO