need excel formula that pulls out a formula

doublebarrier2000 · November 10th, 2003, 8:26 pm

HiDoes anybody know of or have an excel function (probably had to be written in VBA) that returns the text of the actual function in the cell it points to ie if cell A1 has the function "=RAND()" and its value is say 0.5, I need a function that i could type into say B2 "=afunction(A1)" that will return =RAND().thanks

luizvs · November 10th, 2003, 9:01 pm

Try this:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Public Function ret_func(target As Range) As String ret_func = target.FormulaEnd Function~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

doublebarrier2000 · November 10th, 2003, 9:37 pm

dear luizvsthankyou very muchi wish you good health and prosperitrydb