View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] akantrowitz@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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