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,

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,

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,