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

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

"MichaelRobert" wrote in message
...
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

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
"Bob Umlas" wrote in message
...
If you just redefine the range name you shouldn't have to change the data
validation at all.

"MichaelRobert" wrote in message
...
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

Otto:

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

Mike

"Otto Moehrbach" wrote:

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
"Bob Umlas" wrote in message
...
If you just redefine the range name you shouldn't have to change the data
validation at all.

"MichaelRobert" wrote in message
...
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:

Thanks for the suggestion.

Mike

"Bob Umlas" wrote:

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

"MichaelRobert" wrote in message
...
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

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" wrote in message
...
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