Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Entering a Formula in a Cell
'Enters the formula =SUM($G$12:$G$22) in the active cell:
Sub fomula()
    ActiveCell.Formula = "=SUM($G$12:$G$22)"
End Sub