Instead of ignoring blank cells, you could use a dynamic range as the
list source. There are instructions he

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


Ricky wrote:
Hello Experts,
I've checked the "Ignore Blanks" checkbox within Data Validation and all
blank cells are unlisted within the Dropdown list. However, when I copy and
paste as values (that does include blank cells) to replace the Source range,
the Ignore Blanks feature doesn't work anymore. I see a list of blank cells
within the bottom of my dropdown list. What is the workaround to maintain a
dropdown selection list that continues to ignore blanks?

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