The Rows method returns a WksRange object containing all or some of the rows in the current range.
Syntax
object.Rows( Row1, Row2 )
|
Parameter |
Type |
Description |
|
Row1 |
Variant |
optional; first row |
|
Row2 |
Variant |
optional; last row |
Remarks
See Specifying Cell Coordinates for more information on selecting cells.
Example
This example demonstrates how to assign rows of cells within an existing range to the variable named WksRange2.
Dim WksRange2 As Object
Set WksRange2 = WksRange.Rows(Row1:=3, Row2:=7)
Used by: WksRange object