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.

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

Sub WhatEver()
On Error GoTo ExitSub
'Your Code

ExitSub:

End Sub
--
HTH...

Jim Thomlinson


"Aaron" wrote:

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.

One way:

Public Sub AbortOnError()
On Error GoTo ErrHandler

'Your code here

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

In article ,
Aaron wrote:

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.