Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

Worksheet.UsedRange Property

Office 2007
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



Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.