ExcelBanter - find references to cell names

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find references to cell names (https://www.excelbanter.com/excel-discussion-misc-queries/180270-find-references-cell-names.html)

doug2500

find references to cell names

I have an excel 2003 workbook with 25 worksheets. before I delete a nemed
cell in 1 worksheet I would like to know where it is referenced. Any
suggestions? Thanks.

Don Guillett

find references to cell names

for each n in names
msgbox n.name
msgbox n
next n

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"doug2500" wrote in message
...
I have an excel 2003 workbook with 25 worksheets. before I delete a nemed
cell in 1 worksheet I would like to know where it is referenced. Any
suggestions? Thanks.

All times are GMT +1. The time now is 02:09 AM.