ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   AutoFilter in C# (https://www.excelbanter.com/excel-programming/353868-autofilter-c.html)

[email protected]

AutoFilter in C#
 
I can get autofilter to work in Csharp (VSTO 2005) with the following
code:

range.AutoFilter(8, "I",
Microsoft.Office.Interop.Excel.XlAutoFilterOperato r.xlOr, missing,
null);

but i now need to programatically turn autofiltering off.

In VBA, you simply call range.AutoFilter with no arguments so i tried
this.

range.AutoFilter(missing, missing,
Microsoft.Office.Interop.Excel.XlAutoFilterOperato r.xlOr, missing,
missing);

but i got some errors.

Can anyone help me with having the ability to programatically turn off
autofiltering after i programatically turn in on.

thks,
ak



All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com