Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop the "started office live" pop-up to stop. it is checked | Excel Discussion (Misc queries) | |||
1 becomes 10, how can I stop this | New Users to Excel | |||
Stop (C) becoming © | Excel Discussion (Misc queries) | |||
How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions | |||
How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions |