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)