references to named cells

[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.

 

[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.

 

[FSt1]

hi
what do you mean by "currently used"?

Regards
FSt1

 

[doug2500]

Got it. Thanks all.