Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
union of RangeName
Thanks Bob,
I agree and concluded that tasks become hard without VBA. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing For a RangeName | Excel Discussion (Misc queries) | |||
Confused with RangeName CellREfs | Excel Discussion (Misc queries) | |||
Finding Row Numbers Within the RangeName | Excel Programming | |||
RangeName blocks of data | Excel Programming | |||
How to return rangename of selection with VBA | Excel Programming |