R1C1 format using a variable?

Is it possible to use a variable to designate the column in R1C1 format?

If so, what is the proper way to do it?


Example:

R5C"my variable goes here"

One way:

=INDIRECT("R5C" & myVar,FALSE)

Another way:

=INDEX(R5,myVar)

In article <jim37055.1wds6h_1128434711.3939@excelforum-nospam.com>,
jim37055 <jim37055.1wds6h_1128434711.3939@excelforum-nospam.com>
wrote:

> Is it possible to use a variable to designate the column in R1C1 format?
>
>
> If so, what is the proper way to do it?
>
>
> Example:
>
> R5C"my variable goes here"

check out indirect() in help

"jim37055" wrote:

>
> Is it possible to use a variable to designate the column in R1C1 format?
>
>
> If so, what is the proper way to do it?
>
>
> Example:
>
> R5C"my variable goes here"
>
>
> --
> jim37055
> ------------------------------------------------------------------------
> jim37055's Profile: http://www.excelforum.com/member.php...o&userid=27788
> View this thread: http://www.excelforum.com/showthread...hreadid=472969
>
>

Thanks guys, that worked.