R1C1 Style References : Cell Reference « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Cell Reference

R1C1 Style References

 
Sub r1c1()
    Dim formulaString As String
    formulaString = "=R[0]C[-1]+ R[-1]C[0]"
    Cells(2, "B").FormulaR1C1 = formulaString
End Sub








Related examples in the same category

1.A1 Style References
2.Write a formula in the first 10 columns of row 21 in a worksheet that calculates the standard deviation of the values in rows 2 through 20
3.The Cells property is best suited for use with loops because it accepts numerical parameters representing the row and column indices in a worksheet
4.Entering A1 Versus R1C1 in VBA
5.R1C1 Style
6.Use loop to select cells