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.
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