UsedRange Property From Microsoft Excel Visual Basic previous page next page UsedRange Property Returns a Range object that represents the used range on the specified worksheet. Read-only. Example This example selects the used range on Sheet1. Worksheets("Sheet1").Activate ActiveSheet.UsedRange.Select