Range.UseStandardHeight Property

Excel Developer Reference

True if the row height of the Range object equals the standard height of the sheet. Returns Null if the range contains more than one row and the rows aren’t all the same height. Read/write Variant.

Syntax

expression.UseStandardHeight

expression   A variable that represents a Range object.

Example

This example sets the height of row one on Sheet1 to the standard height.

Visual Basic for Applications
  Worksheets("Sheet1").Rows(1).UseStandardHeight = True

See Also