"Indirect" reference to a cell in a code: how to do it?

Hi all,

I am trying to build a line of code with the equivalent of the normal INDIRECT function -for example INDIRECT("a1") - how can i do it?

Basically, whats the correct way to codify the INDIRECT of Range("a1") in a line of code?


Many thanks

BC

Range can take a string value, so it can be used the same as indirect, as long as the string is a
valid address of a cell or range of cells. So if you wanted the same as

=INDIRECT("a1")

then

=Range("A1").Value

or, if the text "A1" is in cell B1, for example

=Range(Range("B1").Value).Value

HTH,
Bernie
MS Excel MVP


"bondcrash" <[email protected]> wrote in message
news:[email protected]...
>
> Hi all,
>
> I am trying to build a line of code with the equivalent of the normal
> INDIRECT function -for example INDIRECT("a1") - how can i do it?
>
> Basically, whats the correct way to codify the INDIRECT of Range("a1")
> in a line of code?
>
>
> Many thanks
>
> BC
>
>
> --
> bondcrash
> ------------------------------------------------------------------------
> bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997
> View this thread: http://www.excelforum.com/showthread...hreadid=468226
>