| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation protection with named ranges
Hi all
When I name a dynamic data range and use that named range it the data validation, the error rotection goes away and it allows me to enter data not on the drop down list. Any ideas here? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Ranges | Excel Worksheet Functions | |||
| dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
| Excel2000: Custom data validation and named ranges | 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 | |||
Threaded Mode
