Charles,

The problem has been solved. Iterations was still on. Setting this off
solved the error.

Thanks!!!!!

"Charles Williams" wrote:

Maybe you have one of these problems?

Range Calculate will fail in Excel 2002/2003 if any of these conditions is
true:

a.. Calculation is set to Manual and Iteration is enabled.
b.. The range being calculated contains a complete circular reference
chain of formulae (you get an error message with Excel 2002 SP3 and later)
c.. The range being calculated partially intersects a multi-cell array
formula.
d.. The Range.Calculate or the Selection.Calculate Methods Fail After You
Update Links to a Dynamic Data Exchange (DDE) Server.
see MSKB 823338
e.. re-entrant calculation is not allowed: you cannot call Range.Calculate
whilst a calculation is in progress
f.. 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.


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Jochem" wrote in message
...
I get a run-time error 1004 when executing the VBA statement:

ActiveSheet.Rows(1).Calculate

Calculation setting is on xlManual. This is needed because the sheet
contains many formulas and full calculation takes to much time.

What can I do to solve this error?



.