Multiple error handling

[tiredofit]

I am trying to handle multiple errors and am a bit surprised the following actually works:

    On Error Goto Errhandler

        ' Do something

Exitpoint:

    On Error GoTo 0 ' OK this line is not actually needed.

    Exit Sub

ErrHandler:

    On Error Resume Next

        'Do something

    On Error GoTo 0 ' Since this line resets the error handling action, why does the resume statement work?

    Resume Exitpoint

I am puzzled by this line:

    On Error GoTo 0 ' Since this line resets the error handling action, why does the resume statement work?

​

Can someone please explain.

Thanks


​

 

[Fluff]

Have a look here http://excelmatters.com/2015/03/17/on-error-wtf/

 

[tiredofit]

Thanks

 

[Fluff]

You're welcome