View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default 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