Thread: How to save current filter of Table(ListObject) and to apply it la
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Smugliy Smugliy is offline
external usenet poster
  
Posts: 10
Default 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

Reply With QuoteReply With Quote