In a remote location make your list with a blank cell at the topname the
listuse =mylist

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"alma st Louis" wrote in message ...
Please help!!!!!!!

I am creating a drop down list in Excel and i need to leave a blank space
at the top of the list.

Thanks.



Nichol wrote:

blank space on dropdown list
07-Nov-08

How do I create a blank space/row at the top of a drop down list?

Previous Posts In This Thread:

On Friday, November 07, 2008 10:42 AM
Nichol wrote:

blank space on dropdown list
How do I create a blank space/row at the top of a drop down list?

On Friday, November 07, 2008 11:04 AM
FSt wrote:

hiset your fill range to have a blank cell at the top.
hi
set your fill range to have a blank cell at the top.

Regards
FSt1

"Nichole" wrote:

On Friday, November 07, 2008 1:18 PM
Nichol wrote:

I apologize, I???m still learning!
I apologize, I???m still learning! I understand how to select the data I
want
and name the list within the name box. Can you please explain how to set
the
fill range? Thank You!!!

"FSt1" wrote:

EggHeadCafe - Software Developer Portal of Choice
EggheadCafe.com MSInfo C# Webservice
http://www.eggheadcafe.com/tutorials...-msinfo-c.aspx