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?