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
|