On error goto 0

[David]

Greetings,
I know that the above has the effect of cancelling 'on
error resume next' but could someone please explain in a
little more detail for my education.
David

 

[Chip Pearson]

David,

On Error Goto 0 simply turns off error handling, and any error that occurs
will raise a run time error and cause the error message box to display.
Despite the "Goto" in the statement, it doesn't cause code to branch to any
statement.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com