I don't know what I did but it is working now, thanks anyway.

"John C" wrote:

Still need formulas to help any further.
--
** John C **


"Zeus" wrote:

I followed the instruction exactly from this site
http://www.contextures.com/xlDataVal01.html#Create
and I still get the same error

"John C" wrote:

Can you give us your actual formula? And if you are trying to do a list of a
named range, can you give us the formula for the named range?
--
** John C **

"Zeus" wrote:

I'm trying to create a simple drop down list but when I enter the name of the
column it gives this error, "The List Source must be a delimited list, or a
reference to a single row or column" It is a simple list in a single column,
why do I keep getting this error?