Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Looking at VBA Help for the Sub statement, the "name" argument "follows
standard variable naming conventions". Looking at VBA Help for variable definition: Variable names must begin with an alphabetic character, must be unique within the same scope, can't be longer than 255 characters, and can't contain an embedded period or type-declaration character. Type declaration characters include $ (string), # (double), % (Integer), & (long). Brackets delimit argument lists, so are not valid within names. Since spaces delimit VBA tokens, a name can't contain a space character, either. This will work: Chart_1A_MS In article , "John Gregory" wrote: I'm having trouble finding what's excluded from use. Is there no list of forbidden characters? I wanted the macro names to correspond to that of the charts. Example "1A) MS" ... without the quotes. When that was rejected, I assumed the bracket was the issue and rewrote to this: "1A_MS". No luck either. So I assumed numerics as first charter were forbidden and chose: "Chart 1A_MS". Rejected! Help please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Tab Names in Macro | Excel Discussion (Misc queries) | |||
Macro names | Excel Discussion (Misc queries) | |||
Macro Names | Excel Programming |