Worksheet.UsedRange Property

  • Article
Excel Developer Reference

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

See Also