| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting unique entries and assigning it to a named range | Excel Discussion (Misc queries) | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| Case Sensitivity problem with data validation | Excel Worksheet Functions | |||
| Data validation named range update | Excel Discussion (Misc queries) | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
Threaded Mode
