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)


ReadOnly Property CurrentRegion As Range
Dim instance As Range
Dim value As Range

value = instance.CurrentRegion
Range CurrentRegion { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Range


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.

See Also


Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace