If there are blank cells in the named range, remove the check mark from
'Ignore blank' in the data validation dialog box.

Native wrote:
> ps - the error message was in List mode. When I put it in custom the
> validation didn't work. Meaning I could type in anything and it would
> allow the input.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html