tutorial for using r1c1 referencing

[rmccafferty]

Does anyone know where there is a decent on line (free) tutorial to learn to use the R1C1 method of referencing cells in macros and formulas?

 

[Michael M]

Yep, right here at Mr Excel

http://www.mrexcel.com/Excel_R1C1_References_training.html]

 

[rmccafferty]

I thank you for the response, but it was not helpful in learning to use R1C1.

That particular podcast gives some history of R1C1 versus A1 styles, but isn't really a tutorial on using R1C1. In fact, it raised a troubling question that it did not answer, apparently saying the when formulas are copied, while the A1 style shows the change in cells it is referencing, the R1C1 style shows every copied formula as identical to the one copied. As presented in the podcast, I have no idea how someone could use the system when it is not clear in the copied fornulas to where is is referring. Or so it seems the way it was presented in the podcast.

Anyone else know of a real tutorial on using R1C1?

 

[xenou]

I found hits in seconds googling r1c1 excel

http://www.lytebyte.com/2008/04/29/what-are-a1-and-r1c1-reference-style-in-excel/

http://theapptimes.com/the-excel-r1c1-reference-explained

To my knowledge, it takes about 10 minutes to learn it but a bit longer to really get used to it and have a feel for it.