UsedRange Property
The UsedRange property returns a range object that encompasses all the used cells in the worksheet. Returns a WksRange object. This is a read-only property.
Syntax
object.UsedRange
Example
This example demonstrates how to return the width of the used column.
Debug.Print Wks.UsedRange.ColumnWidth
Used by: Worksheet object