Range.RowHeight property (Excel)

Returns or sets the height of the first row in the range specified, measured in points. Read/write Double.

Syntax

expression.RowHeight

expression A variable that represents a Range object.

Remarks

The RowHeight property sets the height for all rows in a range of cells.

Use the AutoFit method to set row heights based on the contents of cells.

If a merged cell is in the range, RowHeight returns Null for varied row heights. Use the Height property to return the total height of a range of cells.

When a range contains rows of different heights, RowHeight might return the height of the first row or might return Null.

Example

This example doubles the height of row one on Sheet1.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.