View Source

Sets or returns an Area object that represents the area of cells that the filter is applied to in the worksheet.

public Area Area{ get; set; }

Public Property Area() As Area


//--- Get filter's Area
Area filterArea = autoFilter.Area;

//--- Set filter's Area
autoFilter.Area = filterArea;


'--- Get filter's Area
Dim filterArea As Area = autoFilter.Area

'--- Set filter's Area
autoFilter.Area = filterArea