Range.Row Property

  • Article
Excel Developer Reference

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

See Also