Stop until Calculationstate = xldone

[Tornados]

Hi all,

Probably a simple question, but somehow i'm not ifinding the solution

I am on manual calculation

then at one time i say: application.calculate.

however i really have to know sure that it is done calculating.. wil
it wait for itself ? when exactly does excel move on?

Basically, i need to do this:

if application.calculationstate= xldone then moveon

and if false it should just wait... (application.wait unti
application.calculationstate = xldone.... ) something like this.
Anyone?

Cheers

 

[Tom Ogilvy]

It should wait until calculation is done.