ExcelBanter - Waiting for the calculation to be completed

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Waiting for the calculation to be completed (https://www.excelbanter.com/excel-programming/341502-waiting-calculation-completed.html)

saita

Waiting for the calculation to be completed

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

Waiting for the calculation to be completed

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

saita

Waiting for the calculation to be completed

Dave,
Thanks. It helps.
Sergey

"Dave Peterson" wrote in message
...
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

All times are GMT +1. The time now is 03:38 AM.