Worksheet.UsedRange Property

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`

How big is the worksheet? How much space is occupied in the spreadsheet? return entire area used on sheet used range Used Range Property usedrange UsedRange Property What is the extent of the worksheet?

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

See also: