Sub masque()
Range("A8:A44").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End Sub
Sub masque()
[COLOR=Green]'masque les cellules vide dans la plage de cellules A1:A44[/COLOR]
Range("A1:A44").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End Sub
Sub demasque()
[COLOR=Green]'démasque les cellules vide dans la plage de cellules A1:A44[/COLOR]
Range("A1:A44").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = False
End Sub
Sub masque()
Dim i As Long
[COLOR=Green] 'masque les cellules vide dans la plage de cellules A8:A44[/COLOR]
For i = 44 To 8 Step -1
If IsEmpty(Cells(i, 1)) Or Cells(i, 1) = 0 Then
Cells(i, 1).EntireRow.Hidden = True
End If
Next i
End Sub
Dim Debut As Byte, Fin As Byte
Private Sub Worksheet_Change(ByVal Target As Range)
Dim I As Byte
If Target.Count > 1 Or Target.Address = "$D$3" And Target.Address = "$E$3" Then Exit Sub
Application.ScreenUpdating = False
Debut = 8: Fin = 44: Call Cache(Debut, Fin)
Debut = 56: Fin = 93: Call Cache(Debut, Fin)
Debut = 103: Fin = 140: Call Cache(Debut, Fin)
Application.ScreenUpdating = True
End Sub
Sub Cache(Debut, Fin)
For I = Debut To Fin
Cells(I, 1).EntireRow.Hidden = False
If Cells(I, 2).Value = "" Then Cells(I, 1).EntireRow.Hidden = True
Next I
End Sub