Can I end a sub on error?

[Guest]

I need some code so that if the sub errors anywhere the sub simply ends
instead of giving the user the "Debug or End" message box. Please help.

 

[Guest]

You can use On Error Goto something like this...

Sub WhatEver()
On Error GoTo ExitSub
'Your Code

ExitSub:

End Sub

 

[JE McGimpsey]

One way:

Public Sub AbortOnError()
On Error GoTo ErrHandler

'Your code here

Exit Sub
ErrHandler:
'Handle Error, Clean up, or just exit
End Sub