Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation drop downs don't recognize dynamic named range
I've set up a worksheet where row 2 contains column titles and data
validation. Below this is are the data entry cells with validation lists based on column title. The validation lists are named ranges on another sheet called Tables. I get proper drop downs. When I change a name reference to "=OFFSET(Tables!$B$2,0,0,COUNTA(Tables!$B:$B)-1,1)" I no longer get the drop down. When I try to GoTo the named range it doesn't show on the GoTo list. Formulas like "=CountA(Media)" work correctly. Any help would be appreciated. Glen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation and drop down lists | Excel Discussion (Misc queries) | |||
Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions | |||
Data Validation range | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |