Row Property
The document is archived and information here might be outdated

# 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``````