View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Mark Ivey[_2_] Mark Ivey[_2_] is offline
external usenet poster
 
Posts: 171
Default Capture Error 1004

You could put an error trap in your code or you can totally ignore your
errors like this:

On Error Resume Next

If you want an example of an error trap, take a look at the following
example:

Sub test()

On Error GoTo test_Error

' your code goes here

On Error GoTo 0
Exit Sub

test_Error:

MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure
test of Module Module2"
End Sub

Mark