Rows [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