View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
procreator procreator is offline
external usenet poster
 
Posts: 1
Default Validating range names

I have a program that I am trying to debug. An error occurs when
trying to name a range using a string that "looks" like a cell
reference or formula.

For example, I can name my range "abc123", but not "ab12". No string
beginning with a numeral can be used. Also, "a" works, "b" works, but
not "c".


Does anyone have a snippet of code that validates strings for use as
range names?


Thanks!