CalculateFull in Excel 2002 (XP)
 

Hi,


We have a VBA formula that requires all formulas on all
worksheets in a workbook to be recalculated.

We are having a problem with code that works in Excel
2000, but not Excel 2002 (XP).

The line
Application.CalculateFull

returns error 1004: Method 'CalculateFull' of
object '_Application' failed

I have not found anything in the KB or elsewhere that
this is a known bug, but we cannot get anything to work.

Any ideas?

Thanks,
G72

CalculateFull in Excel 2002 (XP)
 

Where is the application.calculatefull statement located?


Charles Williams
www.DecisionModels.com

"G72" wrote in message
...
Hi,


We have a VBA formula that requires all formulas on all
worksheets in a workbook to be recalculated.

We are having a problem with code that works in Excel
2000, but not Excel 2002 (XP).

The line
Application.CalculateFull

returns error 1004: Method 'CalculateFull' of
object '_Application' failed

I have not found anything in the KB or elsewhere that
this is a known bug, but we cannot get anything to work.

Any ideas?

Thanks,
G72