(Solved) – VBA editor frequently does not flag correct line that error occurs on

(solved)-–-vba-editor-frequently-does-not-flag-correct-line-that-error-occurs-on

Sometimes when an error is encountered, the line that is flaged as where the error occurred is not the actual line where the error occurred. Instead, the VBA IDE flags a line that called a function (that called a function, etc) that had the code that the error occurred. BAD. Does anyone know how to fix this problem? It makes debugging significantly more difficult a you then have to run through that function call LINE BY LINE to find out where the error ACTUALLY occurred. I made a video about the problem to illustrate it better, check it out –

https://youtu.be/LKzYC5h5Npo

Anyone know how to fix this?

Thanks!

Ivan

Leave a Reply

Your email address will not be published. Required fields are marked *