Excel 2000 and 2003

[Guest]

I encountered some problems with excel code developed in excel 2000 and used in excel 2003. Problem was reduced to one line of code:

Worksheets("MKS").Rows(2).Calculate

I took two similar files developed in excel 2000, reduced them to one singel worksheet with no data and one macro with code specified. The confusing fact is that it works in one file and doesn't work in another (Run-time error '1004': Calculate method of Range class failed). Both files are OK in excel 2000.

Any idea?
Leon

 

[Jim Rech]

It might have to do with a change in Excel 2002's (and 2003's) calc engine
discussed briefly here:

http://support.microsoft.com/default.aspx?scid=kb;[LN];292476

 

[Charles Williams]

As well as the change pointed to by Jim, there are some additional
range.calculate problems with excel2002:
see Excel 2002 Range Calculate problems on
http://www.decisionmodels.com/calcsecretsg.htm


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