The ColumnWidth property returns or sets the column width of all the columns in the range. A null is returned if all the column widths are not the same. Returns a variant.
Syntax
object.ColumnWidth
object.ColumnWidth = Width
Parameter |
Type |
Description |
Width |
Double |
required, column width |
Example 1
This example demonstrates how to return the width of columns within a range.
Debug.Print WksRange.ColumnWidth
Example 2
This example demonstrates how to set the column width within a range to 15 units.
WksRange.ColumnWidth = 15
Used by: WksRange object