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