Insane amount of named ranges

[ExcelRoy]

Hi guys,

I have a workbook with an insane amout of named ranges. I need to modify a few p
of the names but because the list in the name manager is so long, when i select one then re-name it it goes back to the beginning and i have to scroll all the way through again. Very time consuming and very frustrating

Is there any other easier way to modify named ranges without scrolling all the way through the lists again and again

Thanks

 

[venkat1926]

remove all names by this macro and rename a few of them

Sub removenames()
Dim nname As name
For Each nname In ThisWorkbook.Names
nname.Delete
Next nname
End Sub