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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
