View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TimD TimD is offline
external usenet poster
 
Posts: 10
Default Named Range name problem in validation

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