Toss in an
application.calculate
before you copy the cell?

saita wrote:

Dear Experts,
I need copy and paste cell value from one sheet to another.
I want to do it only after recalculation of this cell value finished.
How can I verify that calculations of the cell value has been completed?
Thanks a lot
Saita

--

Dave Peterson