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