1 out of 18 rated this helpful - Rate this topic

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.