
01-22-2004, 01:04 PM
|
 |
Microsoft Excel MVP
Forum Leader * Guru *
|
|
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
|
|
It won't translate automatically. You will have to re-write it
To get started, I would turn on the Macro Recorder using Alt|Tools|Macros|RecordMacros... and then perform the actions necessary.. Turn off the recorder and look at the resultant code (hit Alt-F11 to see your code in 'Module1').
From there you will need to clean the code somewhat (maybe, it often just runs!) and or come here for help with that.
But if you have a ton of Macros to re-write, this will take a lot of work, sorry
-- Mike
|
|