Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel old style 4.0 macro
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Discussion (Misc queries) | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Worksheet Functions | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
Changing from format style to list style | Excel Worksheet Functions | |||
Macro records in R1C1 style | Excel Programming |