I "assume" that you're using a userform.
Attached is a userform that contains:
Initialize event: populates the listbox with Range Names in the workbookListbox
Change Event: Selects Named Range (for display purposes)Delete Button:
1) Clears contents of Named Range selected in Listbox2) Deletes
I have a listbox containing some range names. When the user selects one, I
want code to (1) clear the range to which the name refers, (2) delete the
range name, and (3) remove the range name from the listbox.
Thank you.
jgscott3
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you