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

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


wrote:
I am using a range (A1:A10) as a data validation list for Cell B1.
The range A1:A10 is flexible in that I can enter up to 10 items in this
range, which the user can select in cell B1 using the drop down list.

Not all 10 items are entered in the range (A1:A10). Sometimes I need to
enter 6 items, sometimes 9.

Is there a way to show only the number of items that are filled-in in
the list & not the blank ones?

TIA
Vinay



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