Showing unique entries in the Excel Name Manager

paydog23

New Member
Joined
Jul 12, 2017
Messages
13
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

Well-known Member
Joined
Oct 30, 2011
Messages
3,818
You could transfer the information to a worksheet and filter there:


Code:
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
 

Forum statistics

Threads
1,084,856
Messages
5,380,318
Members
401,664
Latest member
traveler84

Some videos you may like

This Week's Hot Topics

Top