Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting the scope of On Error
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name scope within a workbook | Excel Discussion (Misc queries) | |||
Name Scope | Excel Worksheet Functions | |||
Scope of name | Excel Discussion (Misc queries) | |||
Range Name Scope | Excel Discussion (Misc queries) | |||
Change scope of a name | Excel Discussion (Misc queries) |