RowHeight Property

Applies To

Range Object.

Description

Returns the height of all of the rows in the range specified, measured in points (1/72 inch). Read-write.

Remarks

For a single row, the value of the Height property is equal to the value of RowHeight. However, you can also use the Height property to return the total height of a range of cells.

Other differences between RowHeight and Height are the following:

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

See Also

ColumnWidth Property, Height Property, StandardHeight Property.

Example

This example doubles the height of row one on Sheet1.

With Worksheets("Sheet1").Rows(1)
    .RowHeight = .RowHeight * 2
End With