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

excel vba macos excel-2011
Waleed picture Waleed · Apr 20, 2015 · Viewed 24k times · Source

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"

Answer

Comintern picture Comintern · Apr 20, 2015

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.

Related questions

How can I convert a range to a string (VBA)?

What is the best way to convert a range of cells to a string? I have a function that only takes a string as input so I need to convert the range to a string, while retaining as much of …

Read More
Solver.xlam is missing?

I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel. I made sure it worked on both Excel 2010 and Excel 2013 for PC. I then tried to use this same program on Excel 2011, and …

Read More
Load contents of CSV file to array without opening file

I have a requirement to collate over 6000 csv files into a single csv document. The current VBA process is: 1. Open individual CSV data file 2. Load contents of file to array based on number of rows 3. Close individual CSV file 4. Process …

Read More