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