Posted to microsoft.public.excel.programming

Daniel Bonallack[_2_] Daniel Bonallack[_2_] is offline

external usenet poster

Posts: 27

Recalculation of a spreadsheet

Is the command "Calculate" equivalent to F9?
If so, how do I programmatically force a complete
recalculation of the workbook as one would do with
Ctrl+Alt+F9.

The problem I'm finding is that my programmatic
calculation (Comman "Calculate") has not been complete, so
I cut my macro half way to do Ctrl+Alt+F9, then resume the
macro.

Any advice appreciated.

Daniel

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Recalculation	Lpoffe	Excel Worksheet Functions	0	October 2nd 09 06:06 PM
Recalculation?	Mike D.	Excel Discussion (Misc queries)	8	July 13th 07 04:33 AM
recalculation	shmilo	Excel Discussion (Misc queries)	1	February 13th 07 02:40 PM
recalculation in a spreadsheet	Phillip	Excel Discussion (Misc queries)	3	January 25th 07 07:20 PM
Recalculation	R Ormerod	Excel Discussion (Misc queries)	5	March 19th 06 08:54 AM

All times are GMT +1. The time now is 11:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us