Identify if a cell is referenced by other cells
 

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.

Have you tried Tools / Formula Auditing / Trace Dependents

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"drhayes" wrote in message
...
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.

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.

"Ken Wright" wrote:

Have you tried Tools / Formula Auditing / Trace Dependents

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"drhayes" wrote in message
...
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.

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.

On Thu, 24 Feb 2005 14:23:03 -0800, "drhayes"
wrote:

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.

"Ken Wright" wrote:

Have you tried Tools / Formula Auditing / Trace Dependents

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)

----------------------------------------------------------------------------

"drhayes" wrote in message
...
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.

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