Range("temp").Calculate - ERROR

T

Tim

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
 
C

Charles Williams

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
 
Top