Page History

{introducedin: 8.3}
{description}

{excerpt}
Sets or returns an [Area|Area] object that represents the area of cells that the filter is applied to in the worksheet.
{excerpt}

{signature:C#}
public Area Area{ get; set; }

{signature}
{signature:vb.net}
Public Property Area() As Area
{signature}



{example}
{code:csharp|title=C#}

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

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

{code}
{code:vb.net|title=vb.net}

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

'--- Set filter's Area
autoFilter.Area = filterArea
{code}

{example}