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/