Problem with .Calculate

[Boris Merryweather]

Hello,

Both these pieces of code work in Excel 97 and 2000, but not in 2003

Range("C19").Calculate

Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate

I get error 1004, "Calculate method of range class failed"

Any ideas why?

 

[Harald Staff]

Strange. They work perfect here.

Best wishes Harald

 

[Charles Williams]

There are some differences with range.calculate in 2002 & 2003 that can
cause this:
see this page for the ones I know about (found a new one yesterday!)
http://www.decisionModels.com/calcsecretsg.htm


--
Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com

 

[Harald Staff]

Very interesting. Thanks Charles.

Best wishes Harald