There isn't a reset all function, but the following code will remove all
range names from the current workbook:

Sub RemoveNames()

Dim wb As Workbook
Dim n As Name

Set wb = ActiveWorkbook
For Each n In wb.Names
n.Delete
Next n

Set wb = Nothing
Set n = Nothing

End Sub

--
Kevin Backmann


"Jim" wrote:

In Lotus 123 I could rest all named ranges at one time using /rnr. Is there
a way to do this in Excel?