You can use a very simple UDF

Function GetFormula(target As Range)

GetFormula = target.Formula
End Function


Call udf like this
=getformula(S90)



"Gilbert DE CEULAER" wrote:

Cell M20 contains "Whatever".
Cell S90 contains "+M20"
In order to verify things, in T90, I want to know the row, column, or
address of what is really in S90, I mean I want "M20", not the contents
("Whatever").
How can I do that ?
(Actually, in T90? I want to make a formula checking whether the
column-number mentioned in S90 ("M"=13) is less, equal or greater than the
column-number of S90 itself ("S"=19)).