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