Calculating a range in VB Excel XP

  • Thread starter Thread starter Haitch
  • Start date Start date
H

Haitch

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
 
Back
Top