Calculating a range in VB Excel XP
 

Hi,

I've just had a call that a macro I wrote in Excel 2000 won't work in
Excel XP. The error is as follows.

Run time error 1004
Calculate method of range class failed

The obvious thing is is the following statement valid in XP?

ActiveSheet.Calculate

The only other things to do with calculation in the macro are straight
forward calculate statements and this...

Application.Calculation = xlManual
Application.Iteration = True

I'd be surprised it if was this as this line should have already been
executed several times before the error occurs based on how they say
the macro has been running. Although I have found that this doesn't
work in Excel 97 I always though Excel macros were forwards
compatible?!?!

Please help.

thx


---
Message posted from http://www.ExcelForum.com/

Calculating a range in VB Excel XP
 

There are known problems with Range.calculate in Excel XP, but not
Sheet.calculate.

Are you sure you do not have a Range.calculate somewhere?

see http://www.decisionmodels.com/calcsecretsg.htm for details of 5 problems
with range calculate in Excel2002


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

"Haitch" wrote in message
...
Hi,

I've just had a call that a macro I wrote in Excel 2000 won't work in
Excel XP. The error is as follows.

Run time error 1004
Calculate method of range class failed

The obvious thing is is the following statement valid in XP?

ActiveSheet.Calculate

The only other things to do with calculation in the macro are straight
forward calculate statements and this...

Application.Calculation = xlManual
Application.Iteration = True

I'd be surprised it if was this as this line should have already been
executed several times before the error occurs based on how they say
the macro has been running. Although I have found that this doesn't
work in Excel 97 I always though Excel macros were forwards
compatible?!?!

Please help.

thx


---
Message posted from http://www.ExcelForum.com/