View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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.