I have two questions -
1)Is there any way to convert Excel 4 macros to VBA, and
2) I have inherited a macro written in Excel 4.0. It is a
periodically done routine to move dated numbers into a "previous"
column, clear out the cells for new entries. It had been working fine
on WinNT2000, Excel 2000, but somehow, the latest one I received has a
glitch: there are two macros in the file, and each macro has been
duplicated, for a total of four macros. When the button for the
associated macro is pressed, the message "The macro
'Filename.xls'!'MacroName' cannot be found" appears. It appears to me
that the duplicate macro ranges is causing the problem. If so, how do
I get rid of them? I try deleting the range names, but they still
appear in the Tools/Macro dialog box. Thanks for any help.