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
Bookmarks