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?

There is nothing wrong with your code. If the calculation mode is Manual and
both A1 aand A2 contain:

=NOW()

Your code correctly updates only A1. Just make sure that ActiveSheet is
really a worksheet and something else, like a chart.
--
Gary''s Student - gsnu200908


"Jochem" wrote:

> 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?

Even when I do the following:

WorkSheets(1).Rows(1).Calculate

I get the same error. Any idears?

"Gary''s Student" wrote:

> There is nothing wrong with your code. If the calculation mode is Manual and
> both A1 aand A2 contain:
>
> =NOW()
>
> Your code correctly updates only A1. Just make sure that ActiveSheet is
> really a worksheet and something else, like a chart.
> --
> Gary''s Student - gsnu200908
>
>
> "Jochem" wrote:
>
> > 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?

It is not the line which cause this error. Do you get the error if you
calculate the entire worksheet.

Do you have any event code in the worksheet?

What is the error description?

Regards,
Per


On 14 Nov., 15:16, JoHar <Jo...@discussions.microsoft.com> wrote:
> Even when I do the following:
>
> WorkSheets(1).Rows(1).Calculate
>
> I get the same error. Any idears?
>
>
>
> "Gary''s Student" wrote:
> > There is nothing wrong with your code. *If the calculation mode is Manual and
> > both A1 aand A2 contain:
>
> > =NOW()
>
> > Your code correctly updates only A1. *Just make sure that ActiveSheetis
> > really a worksheet and something else, like a chart.
> > --
> > Gary''s Student - gsnu200908
>
> > "Jochem" wrote:
>
> > > 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?- Skjul tekst i anførselstegn -
>
> - Vis tekst i anførselstegn -

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" <(E-Mail Removed)> wrote in message
news:C53B798B-A409-4496-A1D9-(E-Mail Removed)...
>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?
>

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" <(E-Mail Removed)> wrote in message
> news:C53B798B-A409-4496-A1D9-(E-Mail Removed)...
> >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?
> >
>
>
> .
>