UsedRange Property

UsedRange 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: WksDocument object