DefaultColumnWidth Property

 

The DefaultColumnWidth property 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; column width

 

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

 

Wks.DefaultColumnWidth = 20

 

Used by: WksDocument object