Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Range.RowHeight Property

Office 2007
Returns the height of all the rows in the range specified, measured in points. Returns null if the rows in the specified range aren’t all the same height. Read/write Variant.



expression   A variable that represents a Range object.


You can use the Height property to return the total height of a range of cells.

Differences between RowHeight and Height include the following:

  • Height is read-only.
  • If you return the RowHeight property of several rows, you will either get the row height of each of the rows (if all the rows are the same height) or null (if they’re different heights). If you return the Height property of several rows, you will get the total height of all the rows.


This example doubles the height of row one on Sheet1.

Visual Basic for Applications
With Worksheets("Sheet1").Rows(1)
    .RowHeight = .RowHeight * 2
End With

Community Additions

© 2015 Microsoft