Showing unique entries in the Excel Name Manager

paydog23

New Member
Joined
Jul 12, 2017
Messages
25
Office Version
365
Platform
Windows
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?
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
3,884
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
 

Watch MrExcel Video

Forum statistics

Threads
1,090,507
Messages
5,414,963
Members
403,558
Latest member
Hardeni

This Week's Hot Topics

Top