Worksheet.UsedRange Property (Excel)

Returns a Range object that represents the used range on the specified worksheet. Read-only.

Syntax

expression .UsedRange

expression A variable that represents a Worksheet object.

Example

This example selects the used range on Sheet1.

Worksheets("Sheet1").Activate 
ActiveSheet.UsedRange.Select

See Also

Concepts

Worksheet Object

Worksheet Object Members