Works just fine on my version, Excel 2002. What version are you using?

C, by itself is a reserved character.

I created a named range: C_range.

I used that named range as both a source for a data validation drop down
list and in a data validation restricted entry formula. both worked as
expected.

??????

Biff

"TimD" wrote in message
...
I have several named ranges:

CSS_Base_Role-=shtRoleValidData!R1C30:R14C30
C_Asset_Acct-=shtRoleValidData!R2C27:R8C27
C_CPP_Asset_Auth-=shtRoleValidData!R9C27:R15C27
C_Fixed_Asset_Custody_Trans-=shtRoleValidData!R16C27:R17C27
C_Fixed_Asst_Inv-=shtRoleValidData!R18C27:R24C27

I want to use these in data validation. The first works fine. The others
give me a "Cannot use..." error. If I change the first character to a
letter
not in the Name dialog box it works.

What am I missing?

Tim