View original (French)

Unable to clear an advanced filter

ptéranodon Posted messages 465 Registration date   Status Member Last intervention   -  
ptéranodon Posted messages 465 Registration date   Status Member Last intervention   -
Hello,

Good evening everyone ;)

I'm unable to remove an advanced filter in Excel…

When I click on the filter tool, the "clear filter" option is grayed out and inaccessible!

Can someone please advise me?

Thank you

Configuration: Macintosh / Safari 13.0.3

7 answers

  1.
    Frenchie83 Posted messages 2254 Status Member 339
     
    Hello,

    If it's a filtered area other than on-site, simply select that area and press "DEL".

    Now, regarding your previous post, here’s a suggestion that might interest you.

    -Enter your advanced filter criteria (up to 6 lines of criteria), do not touch the "O" column.
    -Click on the "Apply advanced filter" button.

    The code used: 
    Sub Filtre_Avance() Application.ScreenUpdating = False Range("I12:N100").Clear 'Clear previous filter DerLig = Range("A" & Rows.Count).End(xlUp).Row 'Last row of the database DerLig_Fil = Application.WorksheetFunction.CountIf(Range("O3:O8"), "YES") + 2 'detects the last line of the advanced filter area Range("A1:F" & DerLig).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("I2:N" & DerLig_Fil), CopyToRange:=Range("I11:N11"), Unique:=True End Sub


    The example file with 4 choice criteria
    https://mon-partage.fr/f/sMl9yTBZ/

    Best regards
    1