VERY TOUGH PROBLEM

[Guest]

Has anyone been able to get information on the formula contents of a cell
from another cell?
EG.
cell A1 has the formula: =A10
I want to be able to enter some formula into A2 that allows me to see into
the formula in A1. Not the data, not the formatting... rather the formula
itself.
Thanks
If u could please respond to:
(e-mail address removed)

 

[Guest]

hi,
you can toggle to do that
ctrl + ~

 

[Juan Pablo González]

If you install MoreFunc.xll (available at longre.free.fr/english ), you'll
get a FORMULATEXT() function that does just that.

 

[Frank Kabel]

Hi
use the following UDF
public function get_formula(rng as range)
get_formula=rng.formula
end function

 

[Gord Dibben]

David McRitchie's GETFORMULA also does what OP wishes.

http://www.mvps.org/dmcritchie/excel/formula.htm#getformula

Gord Dibben Excel MVP