Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 macro names
I am using Office 2003 on Windows XP.
If I create three identical macros and call them "a1", "aa1", and "aaa1", only the last one called "aaa1" will work. I cannot go to Tools-Macros-Run and run the first two macros. I can step through them at design time, however. Are there new name restrictions in Office 2003? The macros I used are posted below. Sub a1() Cells(5, 5).Select End Sub Sub aa1() Cells(5, 5).Select End Sub Sub aaa1() Cells(5, 5).Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 macro names
I think you're probably right. I really though I had done it before, but I
tried it on a computer with Excel 2002 and it didn't work either. Thanks for the quick response. Ron Dahl "Beto" wrote in message ... Ron Dahl wrote: I am using Office 2003 on Windows XP. If I create three identical macros and call them "a1", "aa1", and "aaa1", only the last one called "aaa1" will work. I cannot go to Tools-Macros-Run and run the first two macros. I can step through them at design time, however. Are there new name restrictions in Office 2003? The macros I used are posted below. Sub a1() Cells(5, 5).Select End Sub Sub aa1() Cells(5, 5).Select End Sub Sub aaa1() Cells(5, 5).Select End Sub I'm not sure if you could do it in previous versions of excel, but I think not, because "a1" and "aa1" might be interpreted as cells so it gets confusing. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 macro names
Ron Dahl wrote:
I am using Office 2003 on Windows XP. If I create three identical macros and call them "a1", "aa1", and "aaa1", only the last one called "aaa1" will work. I cannot go to Tools-Macros-Run and run the first two macros. I can step through them at design time, however. Are there new name restrictions in Office 2003? The macros I used are posted below. Sub a1() Cells(5, 5).Select End Sub Sub aa1() Cells(5, 5).Select End Sub Sub aaa1() Cells(5, 5).Select End Sub I'm not sure if you could do it in previous versions of excel, but I think not, because "a1" and "aa1" might be interpreted as cells so it gets confusing. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 macro names
Ron
Excel thinks a1 and aa1 are cell references and won't allow them to Run or be edited from ToolsMacroMacros. Rename them if you want to run them from the ToolsMacroMacros. Gord Dibben Excel MVP On Mon, 19 Jan 2004 14:18:43 -0700, "Ron Dahl" wrote: I am using Office 2003 on Windows XP. If I create three identical macros and call them "a1", "aa1", and "aaa1", only the last one called "aaa1" will work. I cannot go to Tools-Macros-Run and run the first two macros. I can step through them at design time, however. Are there new name restrictions in Office 2003? The macros I used are posted below. Sub a1() Cells(5, 5).Select End Sub Sub aa1() Cells(5, 5).Select End Sub Sub aaa1() Cells(5, 5).Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define Range Names in Excel 2003-SP2 | Excel Discussion (Misc queries) | |||
Excel 2003 InsertNamesLabels | Excel Discussion (Misc queries) | |||
Subtotal and Names - Excel 2003 | Excel Worksheet Functions | |||
Deleting Names in Excel 2003 | Excel Discussion (Misc queries) |