Rows Method [Worksheet]
The Rows method returns a WksRange object containing one or more entire rows of cells. Returns a Variant.
Syntax
object.Rows( Row1, Row2 )
Parameter | Type | Description |
Row1 | Variant | required, see remarks. The range may have a single row. |
Row2 | Variant | optional, see remarks |
Remarks
See Specifying Cell Coordinates for more information on selecting cells.
Example
This example demonstrates how to assign entire rows of cells to the variable named WksRange.
Dim WksRange As Object
Set WksRange = Wks.Rows(1, 6)
Used by: Worksheet object