This *is* interesting. This behavior also occurs if you have data in
the same row as a blank cell in the validation area when you specify a
finite range rather than a whole column. But it does not occur when
you have data a different column from that in which the validation is
defined.

What to do? You could move your validation data down below your other
data and set your print area to not include the validation area(s).
For that matter, you could move it to column A, below your working
data. Or perhaps somebody else on this list has a better answer,
because for now I don't.

Too bad validation data can't be on a separate sheet.


confused wrote:
Hi,

I am uing data validation on cell A1 and choosing to allow from a list.
In the source box, I am clicking on column L (source =$L:$L). I have
selected the 'ignore blank' checkbox.

column L has 13 names. If there is something in columns A, B, C....etc in
rows 14 or greater then the dropdown list in cell A1 shows blanks along with
the names from column L.

does anyone know how I stop this happening?

Thanks for any help you cangive