Maybe using a dynamic name that grows and contracts with the list would work for
you.

Debra Dalgleish explains it:
http://contextures.com/xlNames01.html#Dynamic

Ron wrote:

I have a drop down list in Excel & would like to add more names...how do I do
this?

--

Dave Peterson