Export (0) Print
Expand All

Worksheet.StandardWidth Property

Office 2007
Returns or sets the standard (default) width of all the columns in the worksheet. Read/write Double.

Syntax

expression.StandardWidth

expression   A variable that represents a Worksheet object.

Remarks

One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used.

Example

This example sets the width of column one on Sheet1 to the standard width.

Visual Basic for Applications
Worksheets("Sheet1").Columns(1).ColumnWidth = _
    Worksheets("Sheet1").StandardWidth



Community Additions

ADD
Show:
© 2014 Microsoft