Hi Keith,

> As best I can tell, Cell Validation drop-down list "Ignore blanks" does
> not work, since blank lines referenced from another worksheet show up the
> drop-down list.along with lines that are not blank.

I think that you misunderstand the Igmore Blanks option.

'Ignore Blanks' does not relate to a data validation list but, rather, to
the cell(s) which are being validated. Thus, for example, if the the ignore
blanks option is selected, a blank entry will be regarded as valid and no
error mesage will be shown in response to a blank entry for a validated
cell.

> Is there some way to eliminate blank lines which show up as gaps in a
> drop-down list?

AFAIK, only by eliminating blanks from the source list.

---
Regards,
Norman


"keithb" <k31thb@yahoo.com> wrote in message
news:%23sXwVOfoFHA.2156@TK2MSFTNGP09.phx.gbl...
> As best I can tell, Cell Validation drop-down list "Ignore blanks" does
> not work, since blank lines referenced from another worksheet show up the
> drop-down list.along with lines that are not blank. Is there some way to
> eliminate blank lines which show up as gaps in a drop-down list?
>
> Thanks,
>
> Keith
>