Range.CurrentRegion Property (Excel)
Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. Read-only.
This property is useful for many operations that automatically expand the selection to include the entire current region, such as the AutoFormat method.
This property cannot be used on a protected worksheet.
This example selects the current region on Sheet1.
This example assumes that you have a table on Sheet1 that has a header row. The example selects the table, without selecting the header row. The active cell must be somewhere in the table before you run the example.