Forum Discussion
find where named range is used/referenced in entire workbook
Hi! I inherited a complex workbook used to run general ledger and reports for a small company. There are many named ranges used for lookup tables as well as pivot tables. In the Name Manager, I ca...
NikolinoDEThis reply is, of course, wrong in one key respect. To look for where a named range is used, the search should be for the Name of the named range, not for the Named Range Reference (from the "Refers To" box).
Even after so long (about 8 months) since this message was sent....you are right to point out that if you want to find where in an Excel workbook a named range is used, you should search by the name of the named range and not by the reference.
Nonetheless, thanks for pointing that out.
Nonetheless, thanks for pointing that out.
