error when running an excel 2004 macro in excel 2000

[BeSmart]

Hi All
An excel spreadsheet containing macros was been created in excel 2004 for
Mac and runs fine in XP and Vista.

Some of the user are using Excel 2000 and when they tried to use the
spreadsheet macro they got a run-time error as follows:

Run-time error '1004':
PasteSpecial method of Range class failed

I need to be able to run the macro across all versions of excel (2000, XP,
Vista, 2004 for Mac) without having different versions of the spreadsheet.

Is excel 2004 VBA compatible in excel 2000?
Is there an easy fix that will work across all versions?

 

[Nigel]

Newer versions of Excel and associated VBA are not backward compatible, some
may work but you certainly cannot guarantee everything will work.

The best approach is to develop or convert the code using the oldest
version. You then have the best chance of it being compatible.

 

[Barb Reinhardt]

But not always!

Newer versions of Excel and associated VBA are not backward compatible, some
may work but you certainly cannot guarantee everything will work.

The best approach is to develop or convert the code using the oldest
version. You then have the best chance of it being compatible.

--

Regards,
Nigel
(e-mail address removed)