I am trying to do some extensive formula writing that involves complex sheet referencing. In my attempts, I do not understand the numbers that come after the R and C in the following. They do not seem to be linear like row and column headings. Could someone explain to me how these numbers work?
ActiveCell.FormulaR1C1 = "=SAF0006!R[-1]C" Range("C3").Select ActiveCell.FormulaR1C1 = "=SAF0006!R[-2]C"
The square brackets are used for relative addressing :
If the active cell is C3 (third row / third column), R[-2]C corresponds to J1 (2 rows backwards and 7 columns forward)
For absolute addressing, do not use the square brackets :
R2C7 corresponds to $G$2 (second row / seventh column)
Thanks to Ivan-hoe for this tip on the forum.
- Excel - Rows and Columns RC - 7
- Rows and Columns RC ✓ - Forum - Programming
- Excel 2007 - Hide a Row or Column - How-To - Excel
- Excel vba search column for value and return row - How-To - Excel
- Excel Conditional Formatting Rows to Columns ✓ - Forum - Excel
- How to automatically copy rows if column contains specific text/value in excel ✓ - Forum - Excel