How do you delete a named range?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you delete a named range? I've looked in Help, the Forum, can't find
anything on deleting a named range. Thanks in advance.
 
From Help on "named ranges"

Change or delete a defined name
On the Insert menu, point to Name, and then click Define.
In the Names in workbook list, click the name you want to change.
Do one of the following:
Change the name
Type the new name for the reference, and then click Add.
Click the original name, and then click Delete.
Change the cell, formula, or constant represented by a name
Change it in the Refers to box.

Delete the name
Click Delete.



Gord Dibben MS Excel MVP
 
Try this:

From the Excel main menu:
<insert><name><define>
Select the name to be deleted
Click the [delete] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
You could also use the following macro to delete ALL named ranges in a workbook

Sub DeleteALLNamedRanges()
For Each dn In ActiveWorkbook.Names
dn.Delete
Next dn
End Sub
 
You can also do this from the immediate window:
ExecuteExcel4Macro "SUM(Delete.name(names()))"
 
Back
Top