I seems like you could really use a Dynamic Named Range (DNR)...
DNR's automatically expand and contract to accommodate available data
Try this...assuming your list is on Sheet2:
O1: MyDV_List
Then list your DV values under O1.
From the Excel Main Menu:
Now...when setting up your Data Validation
Use these settings...
Allow: List
Source: (press [F3]..to see the list of named ranges...and select MyDV_List)
That's it....As you add items to your list the DNR will include them.
For more information about DNR's, see Debra Dalgleish's website:
http://www.contextures.com/xlNames01.html#Dynamic
Does that help?
Bookmarks