Row Property

Microsoft Excel Visual Basic

Row Property

       

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

Example

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

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