EntireColumn Property

The EntireColumn property 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

object.EntireColumn =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.

Debug.Print WksRange.EntireColumn.LastRow

Example 2

This example demonstrates how to set the row height.

WksRange.EntireColumn.ColumnWidth = 20

 

Used by: WksRange object