Stop Macro Execution

[ewize1]

Hi,

Can anyone tell me how can I stop the VBA code from running totally, after I trap an error?

e.g.

On Error Resume Next
If Err.Number = 1004 then
  // code to quit the whole process and return to worksheet view
End If

 

[Juan Pablo González]

either

Exit Sub

or the more "drastic"

End

 

[Davers]

Wouldn't something like:

On Error Resume Next 
If Err.Number = 1004 then 
  Exit Sub
End If

Dave

Edit: Sorry Juan, you beat me!!

 

[ewize1]

Thank you guys.

End

is what I am looking for.