I am trying to use a range that sometimes has blank cells in it, but I don't
want those blank cells to appear on the drop down box.

Is there an easy way of doing this?

TIA