Jim Thomlinson wrote:
Oops... For the life of me I thought you could use non-contiguious ranges in
validation arguments... Should have tested it all the way. Give this a try...


Thanks everybody.
I could sort data to have empty cells at the end and this formula as a
source works perfect

=OFFSET($A$1,,,COUNTA($A$1:$A$7),1)