Base the DV list on a Dynamic Range Name....which automatically expands and
contracts to accommodate the available data.
This link has instructions on building them:
http://www.contextures.com/xlNames01.html#Dynamic
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"hshayhorn" wrote in message
...
I have a drop down list on a spread sheet that gets it's list from a series
of cells. I would like to be able to add to or remove values from the list
without having to change the name of the list. Can someone tell me how
this
is done?