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