Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Use with statement with worksheet
Sub ReferAcrossWorksheets2()
  With Sheets("Sheet1")
    MsgBox WorksheetFunction.Sum(.Range(.Range("A1"), .Range("A10")))
  End With
End Sub