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

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

Excel 2003.

C_Range works by itself. I have serveral named ranges that start with 'C_'
and 'F_' and 'G_'. The ones with the '_' as the second char do not work in a
data validation. I am not saying the they do not work because of the
underscore. The ones with out the '_' do work. If I rename one to start with
a char other than C, F, or G it works. They all refer to the same worksheet.

This is the entire list:

C_Asset_Acct =shtRoleValidData!$AA$2:$AA$8
C_CPP_Asset_Auth =shtRoleValidData!$AA$9:$AA$15
C_Fixed_Asset_Custody_Trans =shtRoleValidData!$AA$16:$AA$17
C_Fixed_Asst_Inv =shtRoleValidData!$AA$18:$AA$24
C_Fixed_Asst_Rpt =shtRoleValidData!$AA$25:$AA$31
C_Key_FI_Rpts_in_AA =shtRoleValidData!$AA$32:$AA$38
C_Period_End_Act =shtRoleValidData!$AA$39:$AA$45
C_Project_Business_Financial_Manager =shtRoleValidData!$AA$46:$AA$47
C_Project_EVM_Specialist =shtRoleValidData!$AA$48:$AA$49
C_Project_Manager =shtRoleValidData!$AA$50:$AA$51
C_Project_Master_Data___Local =shtRoleValidData!$AA$52:$AA$53
C_Project_Reporting =shtRoleValidData!$AA$54:$AA$55
C_Year_End_Closing_in_AA =shtRoleValidData!$AA$56:$AA$57
CompCode =sCompanyCode!$A$1:$B$30
CSS_Base_Role =shtRoleValidData!$AD$1:$AD$14
F_Asset_Acct =shtRoleValidData!$AA$58:$AA$90
F_CPP_Asset_Auth =shtRoleValidData!$AA$91:$AA$123
F_Fixed_Asset_Custody_Trans =shtRoleValidData!$AA$124:$AA$125
F_Fixed_Asst_Inv =shtRoleValidData!$AA$126:$AA$134
F_Fixed_Asst_Rpt =shtRoleValidData!$AA$135:$AA$167
F_Key_FI_Rpts_in_AA =shtRoleValidData!$AA$168:$AA$174
F_Period_End_Act =shtRoleValidData!$AA$175:$AA$207
F_Year_End_Closing_in_AA =shtRoleValidData!$AA$208:$AA$214
FN_Base_Role =shtRoleValidData!$AE$1:$AE$9
G_Asset_Acct =shtRoleValidData!$AA$215:$AA$221
G_CPP_Asset_Auth =shtRoleValidData!$AA$222:$AA$228
G_Fixed_Asset_Custody_Trans =shtRoleValidData!$AA$229:$AA$230
G_Fixed_Asst_Inv =shtRoleValidData!$AA$231:$AA$237
G_Fixed_Asst_Rpt =shtRoleValidData!$AA$238:$AA$244
G_Key_FI_Rpts_in_AA =shtRoleValidData!$AA$245:$AA$251
G_Period_End_Act =shtRoleValidData!$AA$252:$AA$258
G_Project_Business_Financial_Manager =shtRoleValidData!$AA$259:$AA$260
G_Project_EVM_Specialist =shtRoleValidData!$AA$261:$AA$262
G_Project_Manager =shtRoleValidData!$AA$263:$AA$264
G_Project_Master_Data___Local =shtRoleValidData!$AA$265:$AA$266
G_Project_Reporting =shtRoleValidData!$AA$267:$AA$268
Govt_Base_Role =shtRoleValidData!$AF$1:$AF$14


"T. Valko" wrote:

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

Found my problem, I was assigning a named range to a sheet that I had not
created yet. Too much code, not enough coffee.

Sorry for the confusion.