On Error Goto -1

[confusion123]

My error handling tends to be as follows:

On Error Goto Errhandler

     ' some code

Continuation:

    On Error Goto 0

Exit Sub

Errhandler:

    ' do something

    Resume Continuation

End Sub

Is the above good practice?

I assume putting On Error Goto 0, "switches off" error handling.

But I've come across (though rarely):

On Error Goto -1

when is that used?

 

[GTO]

Read Rory's nice explanation Here

@RoryA:

This line still kills me: I'm not actually this blurry in real life unless you're drinking with me.

I just LMAO each time.

Mark

 

[RoryA]

On Error Goto -1

when is that used?

Short answer: if you're using it, you're probably doing something wrong.

 

[RoryA]

@Mark,

It's funny because it's true.

 

[GTO]

Not likely, but if I was ever to suddenly have tons o' funds and made it to East Sussex...

 

[RoryA]

You'd be most welcome!