Range.CurrentRegion Property
Returns a Range object that represents the current region.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property CurrentRegion As Range
Get
'Usage
Dim instance As Range
Dim value As Range
value = instance.CurrentRegion
Range CurrentRegion { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Range
Remarks
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 AutoFormat method.
This property cannot be used on a protected worksheet.