View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Will Finkle Will Finkle is offline
external usenet poster
 
Posts: 12
Default 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,