"Tom Ogilvy" wrote:

the validation list for the second column should be a defined name that has a
refers to formula =Indirect(M70)

--
regards,
Tom Ogilvy

i know and that is what i expect it to be.. so if for example i choose lets
say "cdc" in first column .. i expect the validation list for column N70 to
be = INDIRECT(M70), which should evaluate to = cdc, where cdc is an already
defined list.. so i woul expect to see on my current cell a ComboBox that
would allow me to choose from the values in the cdc list... but it is not
like that... the ComboBox list is empty...