Excel 2002/2003

[Bill]

Can someone please help, I have written a system using
vba in excel xp, I am getting the following error which
is a known fault in excel for xp.

XL2002: Run-Time Error When You Use the Range.Calculate

I have been to the web page that offers the following
solutions:
SYMPTOMS

In Microsoft Excel 2002, when you attempt to run a
Microsoft Visual Basic for Applications (VBA) macro that
contains the Range.Calculate method, you may receive the
following error message:
Run-time error '1004'

Calculate method of Range class failed
CAUSE
This behavior occurs if the following conditions are
true:
.. You use the Range.Calculate method to calculate a
range.

-and-
.. On the Calculation tab of the Options dialog box:
o The Manual calculation option is selected.

-and-
o The Iteration check box is selected.
The Range.Calculate method does not function when both
the Manual calculation option and the Iteration check box
are selected.
WORKAROUND
To work around this issue, turn off iteration or use
automatic calculation in Excel. To do this, follow these
steps:
1. Start Excel 2002.
2. On the Tools menu, click Options.
3. In the Options dialog box, click the Calculation
tab, and then do either of the following:
o Under Calculation, click Automatic if you want to
use automatic calculation.

-or-
o Click to clear the Iteration check box if you
want to turn off iteration.
4. Click OK.

I have tried this both ways but with no success, can
anyone help please.

Regards
Bill

 

[Nick Hodge]

Bill

Sorry, got to this further down the list. It's not mentioned specifically
but a similar issue is and is fixed by the rolled-up SP3 at

http://support.microsoft.com/default.aspx?kbid=836031

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)