Hi!

In A100 enter G100, don't use the plus sign. You don't need to use plus
signs like that in Excel, anyhow.

So, if you have in cells:

G100 = test
A100 = G100

=INDIRECT(A100) will return test.

Biff

"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).