Showing unique entries in the Excel Name Manager

[paydog23]

I have a workbook with hundreds of names. As a result, the Name Manager is hard to navigate--see the image below. Additionally, nearly all my names are defined on a workbook level and refer to ranges, not tables. Consequently, the Name Manager's conventional filter options are useless for finding a specific name. Is there any way to use Auto-Filter style filtering options in the Name Manager?

 

[Worf]

You could transfer the information to a worksheet and filter there:

Sub Tbl()
Dim n As Name, r As Range, w As Workbook, i%
Set w = ActiveWorkbook
[a1] = "Name"
[b1] = "Refers To"
Set r = [a2]
For i = 1 To w.Names.Count
    r = w.Names(i).Name
    r.Offset(, 1) = "'" & w.Names(i).RefersTo
    Set r = r.Offset(1)
Next
End Sub

 

[Fazza]

to populate worksheet with names info: ALT-I-N-P and then ALT-L

similar old thread https://www.mrexcel.com/forum/excel-questions/557441-export-name-manager.html