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.
Debug.Print WksRange. EntireColumn.LastRow
Example 2
This example demonstrates how to set the row height.
WksRange.EntireColumn.RowHeight = 20
Used by: WksRange object