hi patrick

thank you for your help... a question here... so where do i call m
macro from? will your code run according to how long my macro runs o
it's been set to run from 1 to 1000 which i think means 1000 seconds
pardon me if i'm wrong cos i'm not very good with vb... the speed of m
macro varies according to what data is used... could you kindl
advice...? this is the part which i cannot get over...

cheers

hi tom

thank you for your info...

cheer

--
hc
-----------------------------------------------------------------------
hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351
View this thread: http://www.excelforum.com/showthread.php?threadid=26127