Identify if a cell is referenced by other cells

[drhayes]

Is there a function that will tell me whether a cell is referenced by any
other cell in an open workbook? Except, of course, by the cell that is doing
the check.

 

[Ken Wright]

Have you tried Tools / Formula Auditing / Trace Dependents

 

[drhayes]

Thanks for the reply. Trace Dependents and even Find can be used for
selected cells, but I have a very large spreadsheet with substantial data /
calculations. I want to check thousands of cells and am looking for a
formula that I can paste to quickly assess all of them. Trace Dependents /
Find is not efficient.

 

[Myrna Larson]

I don't believe there is any such formula. You can, however, go to
Edit/Goto/Special and select the Precedents or Dependents for a the selected
cell.

 

[Ken Wright]

You can have a piece of code that will find all dependents / precedents of
all the cells within the selection, albeit it will only flag the ones with
deps / precs on the activesheet - Would that help?

--
Regards
Ken.......................


<snip>