What does "= R [-115] C" mean in VBA for Excel 2011 on Mac?

Question

What does " =R[-115]C

" mean in VBA for Excel 2011 on Mac in below code?

Range("F171").Select    'to select a cell
ActiveCell.FormulaR1C1 = "=R[-115]C"

+3

Waleed Apr 20 At 4:45 am

1 answer

Comintern · Accepted Answer · 2015-04-20T05:01:45+0000

This is the offset from the cell where the formula resides. The example you posted ...

"=R[-115]C

"

... would be offset by -115 rows in the same column, so it would be equivalent =F56

.

You can do the same with columns. It...

Range("A1").Select
ActiveCell.FormulaR1C1 = "=RC[1]"

... will give you the formula =B1

.