What is FormulaR1C1 Property in Excel VBA? In R1C1, "R" refers to row, while "C" refers to column. Formula R1C1 allows you set or retrieve formula for a cell, using relative row and column. Why do you need FormulaR1C1? For example, you want to set a formula in C2 to sum A2 and B2, you can type Range("C2").formula= "=A2+B2" or Range("C2").Value = "=A2+B2" Instead of hard code "A2+B2", you can also tell Excel to sum the two cells on the left of the formula cell using FormulaR1C1. "A2+B2...