USING EDIT FIND to locate cell references

If I put various cell references inside a formula, is there an easy way to find the reference without going into each and every cell. For example if cell C6 is "=IF(ISERROR(T9/Q9),"",T9/Q9)" and I want to find all references to T9 can I somehow convert cell C6 to be say the text of the formula and then do a Edit Find on all cells in the worksheet?
I hope that i explained myself. Thanks.

I don't quite follow you, but does this help:

Select T9, then,
<Tools> <Auditing> <Trace Dependents>
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Ron Wilson" <Ron.Wilson.1vf4yb_1126818305.2555@excelforum-nospam.com> wrote
in message news:Ron.Wilson.1vf4yb_1126818305.2555@excelforum-nospam.com...
>
> If I put various cell references inside a formula, is there an easy way
> to find the reference without going into each and every cell. For
> example if cell C6 is "=IF(ISERROR(T9/Q9),"",T9/Q9)" and I want to find
> all references to T9 can I somehow convert cell C6 to be say the text of
> the formula and then do a Edit Find on all cells in the worksheet?
> I hope that i explained myself. Thanks.
>
>
> --
> Ron Wilson
> ------------------------------------------------------------------------
> Ron Wilson's Profile:
http://www.excelforum.com/member.php...o&userid=27295
> View this thread: http://www.excelforum.com/showthread...hreadid=468026
>

[QUOTE=RagDyer]I don't quite follow you, but does this help:

Select T9, then,
<Tools> <Auditing> <Trace Dependents>
--
HTH,

RD
That helps if we are in the same worksheet. What if we are referencing a cell in a different file?

It'll *still* take you there also, as long as the file is open.

Don't you get a arrow pointing to a WS icon?

Hover your cursor to where the arrow meets the icon.
When the cursor changes from a cross to an arrow, *Double* click.

This gives you a "Go To" dialog window, showing *all* the dependent
locations.
You'll notice the focus is in the *empty* "reference" box.
Simply click on one of the locations in the "Go To" window, which enters
that location into the reference box.
Just click <OK>, and you'll be taken to that cell location.

Once you're there, you can create a "precedent" link, to take you back to
where you came from.

Actually, you could "jump" all over the place, once you've established the
links.

Another thought.
If you *start* with the formula cell, and say the *first* precedent cell
reference in that formula is in a closed WB, this will take you to that
first cell, no matter where it is, opened or closed file, same drive or even
a network drive:

<Ctrl> < [ >


--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Ron Wilson" <Ron.Wilson.1vfaib_1126825504.9885@excelforum-nospam.com> wrote
in message news:Ron.Wilson.1vfaib_1126825504.9885@excelforum-nospam.com...
>
> RagDyer Wrote:
> > I don't quite follow you, but does this help:
> >
> > Select T9, then,
> > <Tools> <Auditing> <Trace Dependents>
> > --
> > HTH,
> >
> > RD
> > That helps if we are in the same worksheet. What if we are referencing
> > a cell in a different file?
>
>
> --
> Ron Wilson
> ------------------------------------------------------------------------
> Ron Wilson's Profile:
http://www.excelforum.com/member.php...o&userid=27295
> View this thread: http://www.excelforum.com/showthread...hreadid=468026
>