use the Range property as an argument within another Range property : WorksheetFunction « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. WorksheetFunction

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








Related examples in the same category

1.Finding the maximum value in a range
2.Use the LARGE function to determine the kth-largest value in a range
3.Calculating a mortgage payment
4.Insert the values directly as the function arguments:
5.Using a lookup function
6.A function with a range argument
7.Test the effect of the Option Base statement: declare that arrays are 1-based
8.Use fully qualified properties:
9.Use the Transpose function to turn the one column into one row
10.Use case select statement to call common functions