StandardHeight Property

Returns the standard (default) height of all the rows in the worksheet in points. Read-only Double.

expression   Required. An expression that returns a Worksheet object.

Example

This example resets the rows and columns in the active sheet of Spreadsheet1 to their default size.

Sub Reset_Height_Width()
     Dim shtActive
     Set shtActive = Spreadsheet1.ActiveSheet

     shtActive.Rows.RowHeight = shtActive.StandardHeight
     shtActive.Columns.ColumnWidth = shtActive.StandardWidth
End Sub