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.
|