Range.CurrentRegion

Range.CurrentRegion property

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.

public Range CurrentRegion { get; }