Sorry if i didn't explain it so good
From a formula I have a Dropdownboks, i don't know what it call in english
by excel but in danish excel it calls a Combinationsboks (combineboks)
It takes the value from another Sheet but in the same file
Ek.s from
Beregn!$A$16:$A$23

But not all the cells are filled out allways, but the are filled out from the top and down.

hope some one can help me -- remember i'm not good in excel I'm trying, I'm trying

Alvin


"Alvin Hansen" skrev:

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

best regards

Alvin