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