Range.CurrentRegion (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.

This property is useful for many operations that automatically expand the selection to include the entire current region, such as the XlRangeAutoFormat values. This property cannot be used on a protected worksheet.

Dim rngCurrentRegion As Range
Set rngCurrentRegion = ActiveCell.CurrentRegion