Skip to main content

Range.RowHeight property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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



expression A variable that represents a Range object.


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.


This example doubles the height of row one on Sheet1.

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>