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"


--
jim37055
------------------------------------------------------------------------
jim37055's Profile: http://www.excelforum.com/member.php...o&userid=27788
View this thread: http://www.excelforum.com/showthread...hreadid=472969

One way:

=INDIRECT("R5C" & myVar,FALSE)

Another way:

=INDEX(R5,myVar)

In article ,
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"

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.


--
jim37055
------------------------------------------------------------------------
jim37055's Profile: http://www.excelforum.com/member.php...o&userid=27788
View this thread: http://www.excelforum.com/showthread...hreadid=472969