ColumnWidth Property

ColumnWidth 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

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

WksRange.ColumnWidth = 15

Used by: WksRange object