Brian, as mentioned previously if you want a dynamic range that resizes the list to reflect the count of items see the prior link - it's the best tutorial around on the subject.
In most basic terms - assume I add values to A1 onwards on Sheet2
or if you prefer non-volatile approach and assume entries in A are always text
Now on Sheet1 in cell B1 I want to use the above so I create a DV List with source set as: =_Names
EDIT:
FWIW, EllBol's earlier suggestion will not work if the DV cell is not on the same sheet as the list source - create a Name that reflects the range and use that.
Bookmarks