Use the udf:

The Code for GetFormula
Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function

Source:
http://www.mvps.org/dmcritchie/excel/formula.htm


Mangesh




"SteveR" wrote in message
...
Thanks, but Indirect wants a textual cell address and that's not what
resides
in my target cell (A100).

"paul" wrote:

look at the indirect function
--
paul
remove nospam for email addy!



"SteveR" wrote:

Is it possible to access an address stored in another cell? For
example:

G100 = "test"

A100 = +G100

Now, can I get any information about the address stored in A100, which
is
G100?

In C100, I would like to do something like =ROW(address stored in
A100).