On error End Sub

[Esau]

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

 

[Chip Pearson]

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