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"
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
It's the offset from the cell that the formula is in. The example you posted...
"=R[-115]C"
...would be offset by -115 rows in the same column, so would be equivalent to =F56.
You can do the same thing with the columns. This...
Range("A1").Select
ActiveCell.FormulaR1C1 = "=RC[1]"
...would give you the formula =B1.
