#EXCEL VBA ON ERROR EXIT LOOP HOW TO#

LetвЂ™s remind the full syntax of the On Error statement in VBA first: It is like setting a mouse trap вЂ“ with the difference that you can tell it to drop the mouse off the dumpster or put it in your hands to manage. The VBA On Error statement вЂ“ tells VBA what it should do from now on, within the vicinity of the current block of code (Function or Sub), when an error/exception is raised. So what is our mouse trap when speaking about VBA error handling? The On Error do this statement! Using VBA On Error Obviously a better approach is setting mouse traps in several critical places in the house (corridors etc.) and waiting for the mouse to fall into your trap. Without knowing where the mouse is and when it (the exception/error) will appear (in which line of code) you would need to search entire house to catch it (run through the entire code in our case).

What is error handling? Take this analogy: Say you have a mouse (an error) in the house which turns up every now and then in the least expected moment as slips from your hands (an uncaught exception if you prefer).

#EXCEL VBA ON ERROR EXIT LOOP HOW TO#

No вЂ“ today letвЂ™s learn how to properly handle errors The Mouse Trap Analogy However, today I donвЂ™t want to expand on debugging VBA.

Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. Looking for errors is what developers do most of the time! A critical part of debugging is proper error handling (VBA error handling in our case).Дebugging is twice as hard as writing the code in the first place. Sounds like non-sense? Well I dare say developers spend more time debugging code than writing it. Writing VBA code is hard, but properly debugging code is even harder.

Excel vba on error exit loop