Bonjour,
à tester,
Sub Masquer_ligne()
n = Cells(Rows.Count, "H").End(xlUp).Row
For i = 5 To n
If Cells(i, "H") = 1 Then Rows(i).EntireRow.Hidden = True
Next
End Sub
Sub Afficher_ligne()
n = Cells(Rows.Count, "H").End(xlUp).Row
For i = 5 To n
If Cells(i, "H") = 1 Then
With Rows(i)
.EntireRow.Hidden = True
.RowHeight = 25
End With
End If
Next
End Sub