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
|