I think you misunderstand what John wrote regarding error
handling. To wit, it is NOT required that you use "On Error Goto
0" after an "On Error Resume Next". If you have an "On Error
Goto somewhere", then you DO need to use Resume or Resume Next
(or Exit Sub or End Sub) in your error handling block to restore
VBA's normal error handling.


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






"Darrin Henshaw" wrote in message
...
So far in my short VBA programming experience, I have not done
much in
the way of Error Trapping(I know that is a BAD thing). Lately,
I've been
reading a few VBA books to learn more, and realized I need to
code Error
Trapping.

In Excel 2002 Power Programming With VBA, by John Walkenbach,
he
mentions that after using: On Error Resume Next, you need to
restore
normal error handling with "On Error GoTo 0". My question is if
the
current workbook is closed, without using the "On Error GoTo
0", is
error handling returned to normal? Thanks.

*** Sent via Developersdex http://www.developersdex.com ***