I added the error handler as suggestion and it went from copying 4 times
as it was doing originally to copying about 15 times.

Any other suggestions? This is the first Excel project I have ever had
to do. Most of the stuff I have done is either in Access or VB6.

Thanks,

Jason


--
jaymcgill
------------------------------------------------------------------------
jaymcgill's Profile: http://www.excelforum.com/member.php...o&userid=33799
View this thread: http://www.excelforum.com/showthread...hreadid=535700