references to named cells

D

doug2500

I have an excel workbook with about 25 worksheets. Before I delete a named
cell, I would like to find where it is currently used. ANy suggestions?
Thanks.
 
G

Gary''s Student

First select a cell in an unused area in a worksheet and run:

Sub namer()
Set r = ActiveCell
For Each w In ActiveWorkbook.Names
r.Value = w.Name
r.Offset(0, 1).Value = w.RefersToRange.Address
Set r = r.Offset(1, 0)
Next
End Sub

This will produce a list of the names and associated ranges

Then, for each name, pull-down:

Edit > Find > {the name} > Find All

This will produce a list of where each name is used.
 
Top