The UsedRange property returns a WksRange object, which encompasses all the used cells in the worksheet. 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: WksDocument object