hi,

i have a dropdown box in my sheet. not in a userform. the input range is
like F7:F77 but there are some cells which are blank. how can i get it to
ignore those blank cells so that i do not have a bunch of blank values to
select from the dropdown box. i would NOT Llke to resort column F is at all
possible so that the blank values appear at the bottom. but if this is not
possible, then any other way you would recommend would be apreciated.

thanks in advance,
geebee