Hello all,

I have a question about Data Validation.
I set up a range which can be modified at any given time.
I gave this range a name (Hello1)
Now, on another cell I use Data Validation, List, =Hello1
It works fine, except that if I have empty rows at the end
of my range, it starts with the bottom (which shows
nothing) instead of having the drop down showing the first
few rows of my range.
In other words, I would like to have the Drop Down menu
show the first choices instead of the last choices of my
range...

Example: In E1:E20 I have a list of items, Now I Insert
Name Define E1:E30 with the name "Hello1". I would like
to have it show E1:E8 instead of E23:E30. Is there a way
to do it?

Thanks in advance for any help!
Pitbull