Lifetime of On Error Resume Next

[tiredofit]

How long does On Error Resume Next last?

I thought it lasts until the end but according to this example, it doesn't.

Module1:

Option Explicit

Sub A()

On Error Resume Next

    Dim aa
    
    aa = 1 / 0
    
    Call Module2.b

End Sub

Module2:

Option Explicit

Sub b()

    Dim bb
    
    bb = 1 / 0
    
    Call Module3.c

End Sub

Module3:

Option Explicit

Sub c()

    Dim cc
    
    cc = 1 / 0

End Sub

Running Sub A, the code stops after Sub 2 is run. It never gets to Sub C.

Why is that?

Thanks

 

[NdNoviceHlp]

I believe your error condition changes/ends when U leave any sub or when U change the error condition within the same sub. So U would have to add On error resume next to sub2 if U want it to continue on after an error in Sub2. HTH. Dave

 

[GWteB]

How long does On Error Resume Next last?

It lasts until the procedure in which this statement is used has finished.
The procedure in which the On Error statement is used catches the error, even when other procedures are called.
FYI, it's not VBA specific, error trapping mechanisms in other languages behave the same.
EDIT:
Since you don't have a custom error handler in your procedure, the next line of code is executed (as intended), ie the End Sub line in your Sub A() example.

 

[tiredofit]

Thanks for the response.

 

[GWteB]

You're welcome!