StandardWidth Property

Applies To

Worksheet Object.

Description

Returns or sets the standard (default) width of all the columns in the worksheet, measured in characters of the normal font. Read-write.

Remarks

If the normal font is a proportional font, this property returns the column width measured in characters of the zero (0) character in the normal font.

See Also

ColumnWidth Property, StandardHeight Property, Width Property.

Example

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


Worksheets("Sheet1").Columns(1).ColumnWidth = _
    Worksheets("Sheet1").StandardWidth