DefaultColumnWidth Property

DefaultColumnWidth returns or sets the default column width for the worksheet. Returns a double.

Syntax

object.DefaultColumnWidth

object. DefaultColumnWidth = Width

Parameter	Type	Description
Width	Double	required

Example 1

This example demonstrates how to return the default column width of a worksheet.

Debug.Print Wks.DefaultColumnWidth

Example 2

This example demonstrates how set the default column width of a worksheet to twenty characters.

Wks.DefaultColumnWidth = 20

Used by: WksDocument object