I get an error message "Calculate method of Range class
failed" with the following statement:

Range("temp").Calculate

I have had this problem before and can not remember what
the fix was - any help would be appreciated.

Tim

http://support.microsoft.com/default...76&Product=xlw
XL2002: Run-Time Error When You Use the Range.Calculate Method

--
Regards,
Tom Ogilvy


"Tim" wrote in message
...
I get an error message "Calculate method of Range class
failed" with the following statement:

Range("temp").Calculate

I have had this problem before and can not remember what
the fix was - any help would be appreciated.

Tim

Range Calculate will fail in Excel 2002 if:

a.. Calculation is set to Manual and Iteration is enabled.
b.. or The range being calculated partially intersects a multi-cell array
formula.
c.. The Range.Calculate or the Selection.Calculate Methods Fail After You
Update Links to a Dynamic Data Exchange (DDE) Server.
see MSKB 823338
d.. re-entrant calculation is not allowed: you cannot call Range.Calculate
whilst a calculation is in progress
e.. range.calculate will fail if multiple sheets are selected
If the range you calculate includes a multi-cell array formula and you
subsequently recalculate, the cells in the multi-cell array formula will be
individually calculated.



regards

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Tom Ogilvy" wrote in message
...
Another possibility:

http://support.microsoft.com/default...11&Product=xlw

XL2002: You Receive an Error Message When You Use the Range.Calculate
Method to Calculate Formulas


Regards,
Tom Ogilvy


"Tim" wrote in message
...
I get an error message "Calculate method of Range class
failed" with the following statement:

Range("temp").Calculate

I have had this problem before and can not remember what
the fix was - any help would be appreciated.

Tim