Calculation in Macros

[brettvba]

Does anyone know how to make the macro wait till the calculation is finished?

Brett

 

[DonkeyOte]

there is something called "wait" I think but can't remember the exact code...anyone?

 

[Andrew Poulsom]

As far as I know the Calculate method pauses Excel until calculation is complete.

Is calculation set to automatic? If so:

Application.Calculation = xlManual
' *** Your code goes here ***
Application.Calculation = xlAutomatic

 

[brettvba]

Thanks Guys, I was actually wanting to make sure all the calculations on the sheet were done before I .value the formulas,
I have tried application.calulate that seems to work but takes a very long time,

Brett