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