How do you delete a named range?

[Worksmart]

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.

 

[Gord Dibben]

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

 

[Ron Coderre]

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

 

[Worksmart]

Excellent! This forum never ceases to amaze me.

 

[zodiac711]

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

 

[Bob Umlas]

You can also do this from the immediate window:
ExecuteExcel4Macro "SUM(Delete.name(names()))"