A delimited list is one that you manully type into the refedit. The items
are delimited by a comma:

Screencap: delimited list

http://img513.imageshack.us/img513/8...tedlistkz6.jpg

Screncap: range source

http://img248.imageshack.us/img248/4...esourcefn1.jpg

A range source must be a reference to a single row or column.

Biff

"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.