myRange.Calculate returns error in 2003 but not in 2007

[Gavona]

I am puzzled over this error! The line of code is:
If Application.Calculation = xlCalculationManual Then myRange.Calculate

At this point myRange.address = "$F$8:$F$1962"

The error is Runtime error '1004'
Calculate method of Range class failed

Gavin

 

[SkipVought]

hi,

If Application.Calculation = xlCalculationManual Then [myRange].Calculate

or

If Application.Calculation = xlCalculationManual Then [\Range("myRange").Calculate

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

That is assuming that MyRange is defined on the sheet.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Gavona]

I should have googled first. I rather suspect that this resolves my issue:
kb292476

The Range.Calculate method does not function when both the Manual calculation option and the Iteration check box are selected.

I can't believe I haven't come across the issue before but it seems quite likely that that will resolve the issue.

Skip: myRange is a variable and the vba works in 2007 so I don't think that is the issue.

Sasdly I can't test until next Tuesday.

Gavin