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