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