UsedRange Property

 

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