I don't believe that you can do this. My data lists are always all in one
column...
http://www.officearticles.com/excel/...soft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"brian" wrote in message
...
I'm trying to create a drop down list in a cell, the data range consists
of
multiple rows and multiple columns. I have others just like it working in
the
same workbook but this time it's giving me an error stating:

"the source needs to be a delimited list or reference to a single row or
column".

I must be doing something wrong.