Why Does My Dropdown List Always open at the end of the List instead

Typically that problem is related to the source list having blanks (usually
at the end). If you've left extra space under the list for future entries,
but only want to use the "valid" items, consider using a Dynamic Range Name.
DNR's automatically expand and contract to accommodate the list members.

See Debra Dalgleish''s instructions for using them:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)



"Dasha" wrote in message
...
Why Does My Dropdown List Always open at the end of the List instead

Thank's Ron You Have Solved that one I will Go to Deb's Site and get educated

"Ron Coderre" wrote:

Typically that problem is related to the source list having blanks (usually
at the end). If you've left extra space under the list for future entries,
but only want to use the "valid" items, consider using a Dynamic Range Name.
DNR's automatically expand and contract to accommodate the list members.

See Debra Dalgleish''s instructions for using them:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)



"Dasha" wrote in message
...
Why Does My Dropdown List Always open at the end of the List instead