Yes, you are quite correct with the error handling mechanism, but "On Error
Goto 0" does not need a label.
Read about "On Error Statement" in the VBA Help.

NickHK

"Excelenator"
wrote in message
...

JMB,

Thanks for your reply. I'm intrigued by the "On error resume next"
example. I see that the code that WAS throwing the error will now NOT
throw an error but will execute the next line of code. BRILLIANT!! I
see you inserted "On error Goto 0" after that. Is that simply negating
the "On error resume next" statement so that any other errors will now
throw an exception or should I insert a lable 0 (zero) in the code to
"catch" the exceptions?

Thanks again!


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile:
http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=567685