Range.RowHeight (Excel)

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

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.

ActiveCell.RowHeight = 40