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

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"rk0909" wrote:

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

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

RK

"Dave F" wrote:

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"rk0909" wrote:

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

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 < ]
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rk0909" wrote in message
...
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

You could try XL 4.0 macros.

Check out this old post:

http://tinyurl.com/2scftz


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rk0909" wrote in message
...
thanks Dave.
Is there a way to do this without VBA code?

RK

"Dave F" wrote:

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"rk0909" wrote:

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