If you included any blank cells in the named range, you will be able to
type any value in the cell with data validation. If you're leaving
blanks so the list can grow, you can use a dynamic name for the range
instead. There are instructions he

http://www.contextures.com/xlNames01.html

bevpike wrote:
I wish to create a drop down list and put the list on a different worksheet
than where the drop down will be used. I also want to validate. I was able
to put the actual list on a separate worksheet using a named range but it
when a value not contained in the list was typed in the cell it did not apply
the validation (normally a stop message would come up if you indicate to do
so).

How do I ensure there is validation when a list is located on a separate
worksheet?

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