Hi,
I am using a single column list of values to restrict data entry in a
worksheet column of cells. It works except that it does nothing if the cell
is left blank - though blank is not a part of the list. I checked and
unchecked "Ignore Blank" and only while reading through some discussions did
I realise that these blanks refer to blanks in the list and not in the
entered value itself.

The question is how do I handle a blank entry in the cells ?

Jai