Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |