Row Property
TOC
Collapse the table of content
Expand the table of content

Range.Row Property

Office 2007
Returns the number of the first row of the first area in the range. Read-only Long.

Syntax

expression.Row

expression   A variable that represents a Range object.

Example

This example sets the row height of every other row on Sheet1 to 4 points.

Visual Basic for Applications
For Each rw In Worksheets("Sheet1").Rows
    If rw.Row Mod 2 = 0 Then
        rw.RowHeight = 4
    End If
Next rw



Show:
© 2016 Microsoft