Range.CurrentRegion Property


Returns a Range object that represents the current region.

 property Microsoft::Office::Interop::Excel::Range ^ CurrentRegion { Microsoft::Office::Interop::Excel::Range ^ get(); };
public Microsoft.Office.Interop.Excel.Range CurrentRegion { get; }
Public ReadOnly Property CurrentRegion As Range

Property Value



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(XlRangeAutoFormat, Object, Object, Object, Object, Object, Object) method.

This property cannot be used on a protected worksheet.

Applies to