While Ron's suggestion of Dynamic Range names is far superior, here's an
easy way when you're in a hurry:
Manually insert a cell into the list being referenced (I usually insert
the cell just before the last one).
The range name automatically expands, and you can type the new entry
into the empty cell.
Then, rearranging the list via a sort works.
Darren
-----Original Message-----
From: Ron Coderre ]
Posted At: 19 September 2007 17:24
Posted To: microsoft.public.excel.programming
Conversation: Data validation list type
Subject: Data validation list type
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?