Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Inserts a formula in cell A11 of a worksheet that calculates the sum of the values in the range A2
Sub formal()
    Dim formulaString As String
    formulaString = "=SUM($A$2:$A$10)"
    Cells(11, "A").Formula = formulaString
End Sub