Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recalculate in a macro
I always use the Calculate command. There have been several problems with
this, especially in Excel97, but not in Excel2002, AFAIK -- Kind regards, Niek Otten Microsoft MVP - Excel "Brad Pines" wrote in message ... I want to recalculate my spreadsheet during the run of a macro and then continue processing the macro. How do I make sure that the recalculation is complete before continuing on? I used the following in my macro, but It seams to recalculate the spreadsheet outside of the running of the macro. Workbooks.Item(1).RefreshAll I have Excel 2002 Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculate 1 cell in a macro | Excel Discussion (Misc queries) | |||
Recalculate in VBA | Excel Discussion (Misc queries) | |||
macro to recalculate every 10 seconds | Excel Worksheet Functions | |||
Recalculate changes only | Excel Discussion (Misc queries) | |||
Won't recalculate | Excel Discussion (Misc queries) |