This documentation is archived and is not being maintained.

Worksheet.UsedRange Property

Office 2007
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.

Visual Basic for Applications
Worksheets("Sheet1").Activate
ActiveSheet.UsedRange.Select



Show: