union of RangeName
 

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)

wrote in message
ups.com...
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

union of RangeName
 

Thanks Bob,

I agree and concluded that tasks become hard without VBA.

Cheers