Range.Autofilter once again to destroy(de-filter) an autofilter (individually) but How to destroy(de-filter) an Advanced filter (individually).
Because worksheet.showalldata works collectively.
Range.Autofilter once again to destroy(de-filter) an autofilter (individually) but How to destroy(de-filter) an Advanced filter (individually).
Because worksheet.showalldata works collectively.
Really? Not for me. As far as Excel is concerned, there is only one advanced filter on a worksheet at any one time.Originally Posted by prabhafriend
There can many advanced filters if there are multiple lists.
I beg to differ. And if you use ShowAllData it will simply remove the last one applied - unless you can show me different?
ShowAllData has worked the same for me as Aflatoon
Currently de-filtering individual advanced filters by applying it again but by giving only the headers as a criteria.