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...
Perhaps a belated reply, but my Name Manager contains a button to search for where a name has been used. It searches in all of the Excel objects VBA allows us to inspect, so it also picks up things like Data validation rules, conditional formatting and all sorts of other objects that expose formulas or references. https:\\jkp-ads.com\excel-name-manager.aspx There is even a version which also works on Web Excel.