error when running an excel 2004 macro in excel 2000
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 |
error when running an excel 2004 macro in excel 2000
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 |
All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com