Changing Validation List

[MichaelRobert]

I need to add an Item to my Validation list, but I don't seem to be able to
get rid of the old list. For example my 'old list' was called 'ValidVoltages'
and consisted of: (c3:c5) 12, 24, 120.

My new list - also to be called 'ValidVoltages' - consists of (c3:c6):
(Select one), 12, 24, 120. Problem is that I cannot get rid of the old
selection, nor can I delete its name from the address box.

Help please.

Thanks

 

[Bob Umlas]

If you just redefine the range name you shouldn't have to change the data
validation at all.

 

[Otto Moehrbach]

Select C3:C6.
In versions before 2007, click on Insert - Name - Define.
Type the name ValidVoltages. Do not just click on that name in the list of
names that you see. Doing that will get you the previous range. Type it
in.
In Excel 2007, click on Formulas - Define Name - Define Name. Again, type
in the name. HTH Otto

 

[Ashish Mathur]

Hi,

Names can be deleted by Insert > Name > Define > Select the name and hit the
delete key

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[MichaelRobert]

Bob:

Thanks for the suggestion.

Mike

If you just redefine the range name you shouldn't have to change the data
validation at all.

 

[MichaelRobert]

Otto:

Thanks for the tip. I had not used that route before, but now ...

Mike