StandardWidth Property

Microsoft Office Web Components Object Model

StandardWidth Property

       

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