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