You can't do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ming" wrote in message
...
I create one macro to grad the updated info and paste it to
another spread.
then thing is it will take a while for the data update. so is
there anyway to
control the macro's running time. i.e. after it excute some of
the code, what
kind of code could halt the macro for 1 minute then keep
running again.

thanks a lot for your help.

Ming