| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save current filter of Table(ListObject) and to apply it la
Hi , I am new in Excel Programming .I have following question:
I have an object Excel.ListObject lo = _currentWS.ListObjects[1]; lo.AutoFilter contains current filter which user activated(for example, top10, contains ,greater than ... ). I need to perform lo.AutoFilter.ShowAllData(); In this case user filter disappear. What I need to do for saving current filter and applying it after. Thanks a lot |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply Filter to source of Pivot Table | Excel Worksheet Functions | |||
| Help - Apply Formatting To Current Row | Excel Programming | |||
| Can I apply automatically the same filter on many pivot table ? | Excel Programming | |||
| Can I apply automatically the same filter on many pivot table ? | Excel Programming | |||
| Apply green to current date, red to 2 days overdue and none if pai | Excel Worksheet Functions | |||
Threaded Mode
