ListObject::AutoFilter Property

 

Gets a filtered table.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

C#
C++
F#
VB
Copy 
property AutoFilter^ AutoFilter {
	AutoFilter^ get();
}

Property Value

Type: Microsoft.Office.Interop.Excel::AutoFilter^

An AutoFilter that contains a filtered table.

The following code example adds a ListObject to the worksheet, which corresponds to a table in Excel. The example then populates the table with two rows of arbitrary data and specifies a filter on the table that filters out all the rows whose first column value is not equal to the string value "bb". Next, the example displays the number of active filters found in the table.

This example is for a document-level customization.

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.
Return to top
Show: