ColumnWidth Property

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

WksRange.ColumnWidth= 15

 

Used by: WksRange object