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?

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" <(E-Mail Removed)> wrote in message
news:3E179EBD-2D46-4B3B-BEAE-(E-Mail Removed)...
>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?

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 [private.php?do=newpm&u=]
> Posted At: 19 September 2007 17:24
> Posted To: microsoft.public.excel.programming
> Conversation: Data validation list type
> Subject: Re: 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" <(E-Mail Removed)> wrote in message
> news:3E179EBD-2D46-4B3B-BEAE-(E-Mail Removed)...
> >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?