Range.CurrentRegion Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns a Range object that represents the current region.

public:
 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

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

This property cannot be used on a protected worksheet.

Applies to