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