Instead of including blank cells, you could use a dynamic range as the
list source. There are instructions he
http://www.contextures.com/xlNames01.html
Wes wrote:
I posted a question about returning blanks "Returning a blank for
validationlist", and while trying to figure this out for myself I realized
something else disturbing.
If I choose Ignore blanks (in data validation) this works great until I have
entered something into the list. If I have entered something into the cell,
then deleted it, it is no longer ignored.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html