A classic problem that is evidenced by code working when in debug but
not when run straight through is that there are other process that need
to be given processor time to complete. To do this programmatically you
use the doevents. Finding whereto put it is a bit more difficult but
with this short piece of code you could put a doevents between each
line.

If that works you could try removing them one by one until it goes
wrong again then you will know which is the important one (or more).

Hope this helps. let us know how you get on.

regards,
Anthony


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