Finding precedents or search the formula

[Guest]

All,

I am trying to find the precedents to a cell, using a formula (and not using
the auditing toolbar) can someone help. Also is there a way to search for the
contents of a formula.

e.g if i have a formula "=sum(c1:c2)". I want a formula with the output as
c1 and c2

thanks much.

Rk0909

 

[Guest]

Take a look here for some ideas:
http://www.mvps.org/dmcritchie/excel/formula.htm

Dave

 

[Guest]

thanks Dave.
Is there a way to do this without VBA code?

RK

 

[Ragdyer]

Would you be interested in keyboard shortcuts?

To jump between precendents and dependents,
Select the cell containing the formula, then:
<Ctrl> < [ >

To return to the formula cell, or to start in the dependent cell and jump to
the formula cell:
<Ctrl> < ] >

 

[Ragdyer]

You could try XL 4.0 macros.

Check out this old post:

http://tinyurl.com/2scftz