Share via

StandardWidth Property

  • Article

Returns the standard (default) width of all the columns in the worksheet. The width of one character in the Normal style is used as the unit of measure. Read/write Double.

expression.StandardWidth

*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

Applies to | Worksheet Object

See Also | StandardHeight Property