Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 4th 05, 02:45 PM
BobPetrich
 
Posts: n/a
Default 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   Report Post  
Old January 4th 05, 03:07 PM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old January 4th 05, 03:55 PM
BobPetrich
 
Posts: n/a
Default

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   Report Post  
Old January 4th 05, 04:06 PM
Frank Kabel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 02:49 PM
'SAVE AS' WINDOW ICONS DONT WORK Excel 2000 SP3 Crustysquirrel Excel Discussion (Misc queries) 1 December 10th 04 10:30 PM
pivotcell object to excel 2000 Kellyc Excel Discussion (Misc queries) 0 December 1st 04 03:45 PM


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017