VERY TOUGH PROBLEM

T

Trevor G

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:
[email protected]
 
J

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.
 
F

Frank Kabel

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