Sub Filtrer_les_1()
Application.ScreenUpdating = False
On Error Resume Next 'si aucune SpecialCell
If FilterMode Then ShowAllData 'si la feuille est filtrée
With Range("Q6", Range("Q" & Rows.Count).End(xlUp))
.Replace 1, "#N/A", xlWhole
.EntireRow.Hidden = True 'masque tout
.SpecialCells(xlCellTypeConstants, 16).EntireRow.Hidden = False 'affiche
.Replace "#N/A", 1
End With
End Sub
Sub RAZ()
Rows.Hidden = False 'affiche tout
End Sub