Valid values to use in Names collection?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top