View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Android[_2_] Android[_2_] is offline
external usenet poster
 
Posts: 18
Default Limiting the scope of On Error

I would like to apply On Error error checking within a specific procedure
only.

If I do, something like....

Sub Test()

On Error Goto ErrorHandler
- code -
- code -

ErrorHandler:
msgbox "dddd"
End Sub

Will On Error still be active after this procedure finishes? If so, is
there a way to switch off On Error? I want to handle the error in this
routine, but I want the application to stop and show the error everywhere
else.

Regards,

Android.