Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Use the Range property as an argument within another Range property
Sub range()
    WorksheetFunction.Sum (Worksheets("Sheet2").range(Worksheets("Sheet2"). _
        range("A1"), Worksheets("Sheet2").range("A7")))
    With Worksheets("Sheet2")
        WorksheetFunction.Sum (.range(.range("A1"), .range("A7")))
    End With
End Sub