All,
Ok, have come across many solutions for removing blank values from a drop down list but it seems none of that is useful in my situation.

I have two tabs in the excel 2007 file - tab 1 and tab 2. I have following values on tab 1

Value1


Value2

Value3


There are blank cells in between and they are not consistent. I haved named this entire range as MyRange and using it on tab2 to populate a drop down list using =MyRange.


While showing MyRange values on tab 2 in the drop down list, I want to eliminate the blank values and show only Value1, Value2 and Value3.

Does anyone know how I can do it? Thanks in advance.