In setting up data validation to allow a cell entry from a specified
list, you can define a named range to represent the list and enter the
reference =NamedRange. Is it possible to concatenate two distinct
ranges into a single list?

Not to my knowledge, at least not easily. In the past, I have concatenated
the data in an additional column on my data sheet...even if I then hide that
column from view.

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"DaveO" wrote in message
oups.com...
In setting up data validation to allow a cell entry from a specified
list, you can define a named range to represent the list and enter the
reference =NamedRange. Is it possible to concatenate two distinct
ranges into a single list?

...at least not easily

I was able to write some code to append list1 to the bottom of list2,
and expand the .RefersTo range of list2 to accommodate.

Thanks for your response!

There's a sample file here with combined lists:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0014 - Combine Multiple Lists into One'

DaveO wrote:
In setting up data validation to allow a cell entry from a specified
list, you can define a named range to represent the list and enter the
reference =NamedRange. Is it possible to concatenate two distinct
ranges into a single list?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html