How to destroy (de-filter) individual advanced filters in a worksheet?

[prabhafriend]

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.

[Aflatoon]

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.

[prabhafriend]

There can many advanced filters if there are multiple lists.

[Aflatoon]

I beg to differ. And if you use ShowAllData it will simply remove the last one applied - unless you can show me different?

[CatDaddy]

ShowAllData has worked the same for me as Aflatoon

[prabhafriend]

Currently de-filtering individual advanced filters by applying it again but by giving only the headers as a criteria.