View Single Post
  #3   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

Thank you.

Android.

"Bob Phillips" wrote in message
...
On Error will still be active if you call another procedure, but when the
code terminates, it dies. Any further code run afterwards will return to

the
default error handling.

You can return error handling to the default with

On Error Goto 0

If you want to ignore errors (sic!), or trap them individually, use

On Error Resume Next

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Android" wrote in message
...
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.