Expand Minimize

Worksheet.UsedRange Property (Excel)

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

expression .UsedRange

expression A variable that represents a Worksheet object.

This example selects the used range on Sheet1.

Worksheets("Sheet1").Activate 
ActiveSheet.UsedRange.Select
Show:
© 2014 Microsoft