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