Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Reference worksheet and range by name
Sub ReferAcrossWorksheets1()
  MsgBox WorksheetFunction.Sum(Sheets("Sheet1").Range( _
      Sheets("Sheet1").Range("A1"), Sheets("Sheet1").Range("A10")))
End Sub