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