Excel VBA FormulaR1C1 Property of Range

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...
Read More