View Full Version : On error resume next

07-25-2011, 04:16 AM

I do not like to use the 'on error resume next' statement, since it ignores errors. However, for one single piece of code I have to use it. Is it possible to reverse/cancel the statement by using a line of code when you don't need it anymore? Also, how long will Excel continue to take into account the statement?


07-25-2011, 04:36 AM
You can use either On Error Goto 0 to cancel all error handling or On Error Goto label to initialise your own error handler. On Error Resume Next will carry on until cancelled or until the routine ends.