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