Hi again Debra,
Is there a way to make the dropdown list to default at the top of the list?
Currently, when I click on the dropdown menu, the last item (which is a
blank cell) is highlighted.

Thanks again,
Ricky


"Debra Dalgleish" wrote in message
...
You're welcome. Thanks for letting me know that it worked.

Ricky wrote:
Thanks Debra,
That totally did it. Works like a charm.

Thanks again,
Ricky

"Debra Dalgleish" wrote in message
...

Instead of ignoring blank cells, you could use a dynamic range as the
list source. There are instructions he

http://www.contextures.com/xlNames01.html


Ricky wrote:

Hello Experts,
I've checked the "Ignore Blanks" checkbox within Data Validation and
all
blank cells are unlisted within the Dropdown list. However, when I
copy

and

paste as values (that does include blank cells) to replace the Source

range,

the Ignore Blanks feature doesn't work anymore. I see a list of blank

cells

within the bottom of my dropdown list. What is the workaround to

maintain a

dropdown selection list that continues to ignore blanks?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html