2000 to XP VBA problems?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
Back
Top