Skip to content

Latest commit

 

History

History
49 lines (29 loc) · 1.28 KB

Excel.Range.RowHeight.md

File metadata and controls

49 lines (29 loc) · 1.28 KB
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Range.RowHeight property (Excel)
vbaxl10.chm144190
vbaxl10.chm144190
Excel.Range.RowHeight
103c7209-9a4f-8f9c-7bdc-3013113867a5
05/11/2019
medium

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

[!includeSupport and feedback]