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.

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.
--
Gary''s Student - gsnu200774


"doug2500" wrote:

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.

hi
what do you mean by "currently used"?

Regards
FSt1

"doug2500" wrote:

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.

Got it. Thanks all.

"doug2500" wrote:

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.