Barb,

Names can contain letters, numbers, and underscores, and the first character cannot be a number.
Also, the name cannot be interpreted by Excel as a valid range address in either A1 or R1C1
notation: C, C1, AA45, CC1245, R12C13, etc are invalid. And it's a good idea to have at least 5
leading alpha characters, since Excel 2007 will have up to 4 alphas as column letters.

Visit

http://www.cpearson.com/excel/named.htm

for more.


HTH,
Bernie
MS Excel MVP


"Barb Reinhardt" wrote in message
...
I'm trying to create named ranges programmatically and need to know what
characters are and are not allowed in the names. So far, I assume that _ and
text are included. I know that a lot of special characters are not
(&,+,-,space, etc).

Can someone assist?

Thanks,
Barb