Rows Method [WksRange]

The Rows method returns a WksRange object containing all or some of the rows in the current range. Returns a Variant.

Syntax

object.Rows( Row1, Row2 )

 

Parameter	Type	Description
Row1	Variant	required, see the Remarks below. The range may have a single row.
Row2	Variant	optional, see the Remarks below

 

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

 

Used by: WksRange object