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?