You need to set the Backgroundquery property to false - then your macro will
wait for the refresh to complete.

From help for Refresh method:

expression.Refresh(BackgroundQuery)


--
Regards,
Tom Ogilvy


"wilson" wrote in message
...

I have use the "refresh" but the data can't update before the macro copy
the cell


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/