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