Ignore blank cells when referencing a named range in drop down menus.

Hi All,

I have some pull down menus that use the Indirect function to reference named ranges. In the named ranges, there are numerous blank cells, which is unavoidable. Is there a way to reference a named range but return only the cells that are not blank?

Thanks!

Try this:

http://www.mrexcel.com/forum/excel-q...alidation.html

or this:

http://www.cpearson.com/excel/NoBlanks.aspx