You can use a dynamic range as the source for the list. There are
instructions he

http://www.contextures.com/xlNames01.html

Alvin Hansen wrote:
Hi
I have a dropdownboks there takes the vakue from $a$1:$a$12
but some times there are 4 values sometimes 10 an so on
but in my dropdownboks I have all the values also the lines there are emty
Can't I not tell the dropdownboks only to takes the rows in $a$1:$a$12 where
there are values in

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you
It's working

Alvin


"Debra Dalgleish" skrev:

You can use a dynamic range as the source for the list. There are
instructions he

http://www.contextures.com/xlNames01.html

Alvin Hansen wrote:
Hi
I have a dropdownboks there takes the vakue from $a$1:$a$12
but some times there are 4 values sometimes 10 an so on
but in my dropdownboks I have all the values also the lines there are emty
Can't I not tell the dropdownboks only to takes the rows in $a$1:$a$12 where
there are values in

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html