UsedRange Property
TOC
Collapse the table of content
Expand the table of content

Worksheet.UsedRange Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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:
© 2016 Microsoft