Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. 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