to help isolate the problem I recommend temporarily commenting out the
ON Error statement and changing the Break On error option in VBA menu

1) Tools - Options General - Error Trapping

Set to break on all errors.


2) Go back and run your macro again and see if any other error messae
come up. I suspect there is a hidden error that is getting bypassed by
the ON Error Statement. You need to find and fix the 1st problem which
should resolve the lock up.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186927

http://www.thecodecage.com/forumz/chat.php