XP has functionality that wasn't available in 97. You should develop your
code on the earliest version that you intend to use, and then port up, not
the other way.

What is the code that is failing?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alex" wrote in message
. ..
I am a fairly light excel user so my problem might be obvious to some
(hopefully).

I have a spreadsheet with a macro written in XP which works fine, no
glitches or bugs. I have tried to run the same file on Excel '97 and its
coming up with an error.

Am I wrong to assume that there is a compatibility problem? I though that
the code would be the same in both versions.

Please enlighten me.

Thanks

alex.geo