View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keithb keithb is offline
external usenet poster
 
Posts: 44
Default Cell Validation "Ingnore Blanks" doesn't work

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