VBA names - where do they refer?

Question

I defined a large number of named cells on one sheet of a workbook. Each name can be used several times (or never) on this sheet or in other books. Is there a way to get a list of where else names are used in the book?

For example, let's say I define the name Fred for a cell on Sheet1 . On sheet2, cell B6, there is an equation that =Fred*6 . How to get a function to return Sheet2!B6 and any other places that use Fred ?

Hope this is clear enough. :)

Answer 1

The free version of JKP and My Name Manager Addin can show you where a particular name is used.
You can download this supplement from http://www.decisionmodels.com/downloads.htm
When I wrote an extended version of the FastExcel name manager, I added a Name Map object, which indicates the number of names used (or not) for the sheets and other names.
This is done by parsing Names from all formulas on all sheets and formulas in names (recursively) using a special analyzer and evaluating cases such as using INDIRECT.