| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I update Excel 2000 macros to work in Excel 2002?
Working in Excel 2002/XP on an Excel worksheet which was created in Excel
2000, I get an error message "Subscript out of range". How do I update the macro to work in Excel 2002? |
|
#2
|
|||
|
|||
|
Hi
normally the macro should work without a problem. Best to post the part of your code which generates this error -- Regards Frank Kabel Frankfurt, Germany "BobPetrich" schrieb im Newsbeitrag ... Working in Excel 2002/XP on an Excel worksheet which was created in Excel 2000, I get an error message "Subscript out of range". How do I update the macro to work in Excel 2002? |
|
#3
|
|||
|
|||
|
And where do I find "that part of the code which generates this error"? (I'm
a novice at macros). Thank you! "Frank Kabel" wrote: Hi normally the macro should work without a problem. Best to post the part of your code which generates this error -- Regards Frank Kabel Frankfurt, Germany "BobPetrich" schrieb im Newsbeitrag ... Working in Excel 2002/XP on an Excel worksheet which was created in Excel 2000, I get an error message "Subscript out of range". How do I update the macro to work in Excel 2002? |
|
#4
|
|||
|
|||
|
Hi
then the error occurs you should have the option 'Debug#. Then you should see the code. -- Regards Frank Kabel Frankfurt, Germany "BobPetrich" schrieb im Newsbeitrag ... And where do I find "that part of the code which generates this error"? (I'm a novice at macros). Thank you! "Frank Kabel" wrote: Hi normally the macro should work without a problem. Best to post the part of your code which generates this error -- Regards Frank Kabel Frankfurt, Germany "BobPetrich" schrieb im Newsbeitrag ... Working in Excel 2002/XP on an Excel worksheet which was created in Excel 2000, I get an error message "Subscript out of range". How do I update the macro to work in Excel 2002? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
| 'SAVE AS' WINDOW ICONS DONT WORK Excel 2000 SP3 | Excel Discussion (Misc queries) | |||
| pivotcell object to excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
