View Single Post
  #2  
Old June 1st, 2010, 07:15 PM posted to microsoft.public.excel.worksheet.functions
Roger Govier[_8_]
external usenet poster
 
Posts: 338
Default Drop Down Lists 2007

Hi

It sounds as though your "blahList" is more than one column Wide.

--
-------
Regards
Roger Govier

"tlynn" wrote in message
...
I have followed all the steps in creating a drop down list in Excel 2007:

Created Named list on seperate sheet
goto the sheet that the drop down will be on and select the appropriate
cell
Data Data Validation Allow:List Source: =BlahList Click "OK"

...And then, I get this message every time:

"The list source must be a delimited list, or a reference to single row or
column."

So. What am I doing wrong? Ive been to Youtube, and read numerous
articles
on here about "Drop Down Lists" and still am having an issue with this one
feature. Thank you for your time and attention in this...


__________ Information from ESET Smart Security, version of virus
signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com