VBA code randomly stopping

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Seth Schrock
    Recognized Expert Specialist
    • Dec 2010
    • 2965

    VBA code randomly stopping

    I have some code that I'm trying to run in Excel 2013 VBA. Periodically when I try to run my code, I get a message saying "Code execution has been interrupted". If I click debug and then F8 the rest of the way through it, everything runs fine. I can also click Continue and it works. It almost never stops at the same place. I've never had this happen in Access VBA so I'm a little lost as to why it keeps doing this.
  • Seth Schrock
    Recognized Expert Specialist
    • Dec 2010
    • 2965

    #2
    After continuing to google this problem, I found this:

    "After some googling I've found better (quicker) solution: just end macro, switch to the VBE and hit Ctrl+Break. After that the code execution doesn't break."
    Link: http://social.msdn.mic rosoft.com/Forums/en-US/...

    Comment

    Working...