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

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




"BeSmart" wrote in message
...
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

But not always! ;)

"Nigel" wrote:

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




"BeSmart" wrote in message
...
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