union of RangeName

[rodolforocco]

Hello,

I have four columns with data and i'd like to use this four columns in
my Data > Validation > List.
Unhappyly, Excel don't let use more than one column in List >
Validation. It shows me the the message the List source must be a
reference to a single column. So how can i figure it out without VBA ?

I was thinking in built a rangename that join this four column in 1
continuous array.

Thanks in advance

 

[Bob Phillips]

Building a rangename that covers 4 columns won't help, you can do that
without VBA, doesn 't work , the error message says it must be a single row
or column.

You will have to create a single dimension list from your multi-dimension
list, and point the DV at that.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[rodolforocco]

Thanks Bob,

I agree and concluded that tasks become hard without VBA.

Cheers