Somewhere before you get the error, put this line in:

On Error Goto ErrHnd

Then at the end of your subroutine (before End Sub) put this:

Exit Sub

ErrHnd:

Err.Clear

End Sub

This will essentially ignore your error and not show a message. Not
that it ignores all errors, so if things stop working right, you wil
need to comment out the On Error Goto ErrHnd statement.



--
Message posted from http://www.ExcelForum.com