I have recently upgraded to XP Pro from 2000 and when
running a macro embedded in a workbook I am now getting VB
errors. For example, the XP version gives me the
following error code:

Run time error 1004 Calculate method of range class
failed". This bombs out on a model with about 5 tabs in
it on the following piece of code:


Case Else

Range("Daily").Calculate

dtCurrDt = Range("Daily")

End Select

The error is on Range("daily").calculate.

Is there something I missed on setting up XP or is this
common place? I works fine on 2000 so I am a bit confused.
This also happens on other work books with the same code #
but not necessarily the "Daily" line.

Thanks in advance
Jim

You may have been bitten by the problem discussed he

http://support.microsoft.com/default...Product=xl2002

--
Jim Rech
Excel MVP