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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation protection with named ranges
If the dynamic range contains a blank cell, you'll be able to enter any
value in the cell with data validation. Ben H wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
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 |