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, 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 twenty characters.

Wks.DefaultColumnWidth = 20

 

Used by: Worksheet object