You need to turn on R1C1 reference styles in Excel. See below, from the Excel help file:
About R1C1 references
In R1C1 reference style, Microsoft Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed by a column number. For example, the absolute cell reference R1C1 is equivalent to the absolute reference $A$1 in A1 reference style. If the active cell is A1, the relative cell reference R[1]C[1] refers to the cell one row down and one column to the right, or B2.
The following are examples of references in R1C1 style.
Reference Meaning
R[-2]C A relative reference to the cell two rows up and in the same column
R[2]C[2] A relative reference to the cell two rows down and two columns to the right
R2C2 An absolute reference to the cell in the second row and in the second column
R[-1] A relative reference to the entire row above the active cell
R An absolute reference to the current row
When you record a macro, Excel records some commands by using R1C1 reference style. For example, if you record a command such as clicking the AutoSum button to insert a formula that sums a range of cells, Excel records the formula by using R1C1, not A1, references.
Tip To turn R1C1 reference style on (or off), click Options on the Tools menu, and then click the General tab. Under Settings, select or clear the R1C1 reference style check box. |
