Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Valid values to use in Names collection?
Hi,
By accident, I've just learned that hyphen (-) cannot be used in the name of a Named Range. So I've been trying to find a list of the valid (or invalid) characters for a name, but so far, no luck. Anyone know? I know of two so far: " " and "-". I imagine most symbols are out, but to be safe, I want to build in a fixup so that bad chars will be removed before using trying to hand them to Names.Add, so having the complete list would be a great help. Thank you kindly, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Valid values to use in Names collection?
Taken from Excel Help "About labels and names in formulas"
<quote Guidelines for names What characters are allowed? The first character of a name must be a letter, an underscore character (_), or a backslash (\). Remaining characters in the name can be letters, numbers, periods, and underscore characters. <unquote "Will Finkle" wrote: Hi, By accident, I've just learned that hyphen (-) cannot be used in the name of a Named Range. So I've been trying to find a list of the valid (or invalid) characters for a name, but so far, no luck. Anyone know? I know of two so far: " " and "-". I imagine most symbols are out, but to be safe, I want to build in a fixup so that bad chars will be removed before using trying to hand them to Names.Add, so having the complete list would be a great help. Thank you kindly, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Valid values to use in Names collection?
Doh!! I have forgotten all about the humble F1 key!! LOL. Thank you very much.
"Cringing Dragon" wrote: Taken from Excel Help "About labels and names in formulas" <quote Guidelines for names What characters are allowed? The first character of a name must be a letter, an underscore character (_), or a backslash (\). Remaining characters in the name can be letters, numbers, periods, and underscore characters. <unquote "Will Finkle" wrote: Hi, By accident, I've just learned that hyphen (-) cannot be used in the name of a Named Range. So I've been trying to find a list of the valid (or invalid) characters for a name, but so far, no luck. Anyone know? I know of two so far: " " and "-". I imagine most symbols are out, but to be safe, I want to build in a fixup so that bad chars will be removed before using trying to hand them to Names.Add, so having the complete list would be a great help. Thank you kindly, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Names referring to valid range in the active workbook | Excel Programming | |||
Memory leak in names collection? | Excel Programming | |||
adding a VBA name to workbook names collection | Excel Programming | |||
Adding Range to Worksheet Names Collection | Excel Programming | |||
Names Collection | Excel Programming |