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?

--
Thank for your help
BeSmart