EntireColumn Property

EntireColumn returns a new range containing every cell in each column of the current range. Returns a WksRange object. This is a read-only property.

Syntax

object.EntireColumn

Remarks

This is the equivalent of clicking on a column letter button in the worksheet.

Example 1

This example demonstrates how to return the last row with data values.

Debug.Print WksRange.EntireColumn.RowCount

Example 2

This example demonstrates how to set the column width.

WksRange.EntireColumn.ColumnWidth = 20

Used by: WksRange object