If you're using the range of cells as the source for a drop down list then
the source has to be a contiguous range (no empty cells between entries).

--
Biff
Microsoft Excel MVP


"Scott" wrote in message
...
How do you ignore blank cells in data validation ranges? I know there's a
check box that says "Ignore Blanks" but that doesn't seem to work for me.
If
I have a list of potentially 5 cells that could contain values, but only 3
of
them do, is there a way to ignore the 2 blank cells, but when there is a
value there, for it to register?

Thanks.