Hi,

Instead of using a named range, you would have to type your list in
the data validation dialog box.

HTH
Carim