If you put error trapping in your code (there are plenty of posts on
this subject) when the error occurs control will pass to the error
handling code rather than just crashing.

HAve a look in this forum and in the help files. If you get stuck post
again.

Things to look for:
- on error goto label
err.number
err.description
resume label

have fun


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=535505