Esau,

Structure your code similar to the following:

Sub AAA()
On Error Goto EndSub
'
' your code here
'
EndSub:
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Esau" wrote in message
...
On Error Resume Next
This works great but I need to stop
the macro

On Error End Sub
This will not work how can I write it so it will


Thank You

Esau