Stop until Calculationstate = xldone
 

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

--
Tornado
-----------------------------------------------------------------------
Tornados's Profile: http://www.excelforum.com/member.php...nfo&userid=417
View this thread: http://www.excelforum.com/showthread.php?threadid=26413

Stop until Calculationstate = xldone
 

It should wait until calculation is done.

--
Regards,
Tom Ogilvy

"Tornados" wrote in message
...

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.. will
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 until
application.calculationstate = xldone.... ) something like this..
Anyone?

Cheers.


--
Tornados
------------------------------------------------------------------------
Tornados's Profile:
http://www.excelforum.com/member.php...fo&userid=4178
View this thread: http://www.excelforum.com/showthread...hreadid=264131