Function to convert a formula to text
Lawson,
Clicking Ctrl+` will show all formalas on the worksheet.
"lawson" wrote:
Hello all,
i presently have a function that converts a formula entered in a cell into
text such that a viewer can see the formula as it was typed:
Function ShowFormula(rg As Range) As String
ShowFormula = rg.Formula
End Function
the user simply types =ShowFormula(cell) and the formula is revealed.
the problem is that the result is in the format =d4+d5-SQRT(f5) when i would
like it to read =44+33-sqrt(69)
is there a way to modify the function such it it shows the numbers from the
linked cells rather than the address of the cell?
thank you very much
|