Hello,

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

Range("C1:D9").Calculate

Worksheets("Sheet1").UsedRange.Columns("A:C").Calc ulate

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

Any ideas why?

Strange. They work perfect here.

Best wishes Harald

"Boris Merryweather" <boris dit merryweather hat virgin dit net skrev i
melding ...
Hello,

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

Range("C1:D9").Calculate

Worksheets("Sheet1").UsedRange.Columns("A:C").Calc ulate

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

Any ideas why?

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" wrote in message
...
Strange. They work perfect here.

Best wishes Harald

"Boris Merryweather" <boris dit merryweather hat virgin dit net skrev i
melding ...
Hello,

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

Range("C1:D9").Calculate

Worksheets("Sheet1").UsedRange.Columns("A:C").Calc ulate

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

Any ideas why?

Very interesting. Thanks Charles.

Best wishes Harald

"Charles Williams" skrev i melding
...
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