View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Changing Validation List

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