PaulD,

I used your macro instead of mine, and it sped up to about 3 second
per sheet. This was very useful because my macro got hung up somewher
and took forever. Thanks again. Updated over a half-millio
cells......

--
trickdo
-----------------------------------------------------------------------
trickdos's Profile: http://www.excelforum.com/member.php...nfo&userid=940
View this thread: http://www.excelforum.com/showthread.php?threadid=27756