Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Use fully qualified properties
Sub sumDemo()
     MsgBox WorksheetFunction.Sum(Sheets("Sheet1").Range(_
                                Sheets("Sheet1").Range("A1"), _
                                Sheets("Sheet1").Range("A10")))
End Sub