2013-03-07

Phantom Debug Error Messages

Phantom debug error messages while coding VBA has always been a thorny problem, but I recently ran across a technique that seems to work. This is the quote of the person that presented it:
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.
As a series of steps:
  1. When the error message occurs, click Debug
  2. Press CTL+BRK
  3. Depending on the code location press F5
That's it!