Thanks Dave,
Yes, but that list is serving another purpose the way it is.This validion
list is what I call "Type" and the next column list the valid "Sub-type" for
each Type. The number of empty cells correspond to the number of sub-types
for each type.

"Dave O" wrote in message
ups.com...
One solution would be to go to the cell range that is referenced by
your data validation list and sort it. That would move empty cells to
the bottom of the list, out of the way.