A Question About On Error Do X

[Photomofo]

I don't have a lot of experience with On Error statements. I'm currently working on a program that has several failure mechanisms. Do I have to put On Error statements in each sub-routine or can I have a Global On Error statement that covers all the sub-routines?

I only have one On Error statement in this program currently. Assuming there is a way to set up a Global On Error condition will the current On Error statement supersede the Global On Error statement?

 

[Zot]

I believe that there is no Global On Error..

Here is good article on Or Error

VBA On Error - Error Handling Best Practices - Automate Excel

In this ArticleVBA Errors Cheat SheetErrorsVBA Error HandlingVBA On Error StatementOn Error GoTo 0On Error Resume NextErr.Number, Err.Clear, and Catching ErrorsOn Error GoTo LineVBA IsErrorIf Error VBAVBA Error TypesRuntime ErrorsSyntax ErrorsCompile ErrorsDebug > CompileOverFlow ErrorOther VBA...

www.automateexcel.com

 

[Alex Blakenburg]

Its just a question of granularity. You can have the On Error Statement in the Top Sub Routine and if there is an error in a called subroutine with no error handling, the called sub as a whole will error out and the Top Sub On error statement will be invoked.
This will give very little indication of where the error actually occured and the on error action will need to be very non-specific.

Any error handling in a called subroutines will have a scope of just that sub routine (but will in turn cover any errors in the lower level routines that it calls, and don't have their own error handling)

 

[Photomofo]

Thank you. I'll give it a shot.