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.
Remarks
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.