View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben H
 
Posts: n/a
Default 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?