Option Explicit
Sub Filtrer()
Range("au1:au1").SpecialCells(xlCellTypeFormulas, 16).Interior.ColorIndex = 1
ActiveSheet.Range("a1:au1").AutoFilter Field:=47, Operator:=xlFilterNoFill
End Sub
Sub Afficher()
Range("au1:au1").SpecialCells(xlCellTypeFormulas, 16).Interior.ColorIndex = xlNone
ActiveSheet.AutoFilterMode = False
End Sub