on error don't resume next?
 

Hi.
I have a procedure that uses "On Error Resume Next" at the beginning of the
procedure. However, I don't want the procedure to pass by errors after a
certain point. Is there a way to tell vba to "on error dont resume next"? In
other words, is there a way to cancel the "on error resume next" within a
procedure?
Thanks,
Albert C.

on error don't resume next?
 

Albert,
On Error GoTo 0

Check the help for "On Error Statement".

NickHK

"Albert" wrote in message
...
Hi.
I have a procedure that uses "On Error Resume Next" at the beginning of
the
procedure. However, I don't want the procedure to pass by errors after a
certain point. Is there a way to tell vba to "on error dont resume next"?
In
other words, is there a way to cancel the "on error resume next" within a
procedure?
Thanks,
Albert C.