| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Named Range inside a Data Validation list ?
You can use a dynamic range in the same workbook. If the list is in
another workbook, there are instructions he http://www.contextures.com/xlDataVal05.html Richard wrote: Is it possible to use a 'Dynamic Named Range' in the Data Validation list ? When I tried, the Data Validation List did NOT show any entries... ?! (it remained empty, enven though the Dynamic List was working right! Details on 'Dynamic Named Ranges' can be found he http://www.ozgrid.com/Excel/advanced-dynamic-ranges.htm If this is not possible, is there any ways/workarounds to create a Data Validation List, based on a Dynamic Named Range ? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation List from a Dynamic Named Range on Another Workshe | Excel Worksheet Functions | |||
| Data Validation via Dependent List defined by Dynamic Range | Excel Discussion (Misc queries) | |||
| Changing named Validation list to Dynamic list. | Excel Discussion (Misc queries) | |||
| Data validation drop downs don't recognize dynamic 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 | |||
Threaded Mode
