1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| Public DerniereLigneEvenement As Long
Public ShEvenement As Worksheet
Public AireEvenement As Range
Public CelluleEvenement As Range
Public ColMes As Long
Public ColEvenement As Long
Public LigneDeTitreEvenement As Long
Sub AfficherTousLesEvenements()
ActiveSheet.Rows.Hidden = False
End Sub
Sub MasquerLesEvenementsTermines()
Set ShEvenement = Sheets("Feuil1")
With ShEvenement
ColMes = .Range("AireRemiseEnService").Column
ColEvenement = .Range("AireDateEvenement").Column
DerniereLigneEvenement = .Cells(.Rows.Count, ColEvenement).End(xlUp).Row
LigneDeTitreEvenement = 2
Set AireEvenement = .Range(.Cells(LigneDeTitreEvenement + 1, ColMes), .Cells(DerniereLigneEvenement, ColMes))
For Each CelluleEvenement In AireEvenement
If CelluleEvenement <> "" And CelluleEvenement.Offset(0, ColEvenement - ColMes) <> "" Then
.Rows(CelluleEvenement.Row).EntireRow.Hidden = True
End If
Next CelluleEvenement
Set AireEvenement = Nothing
End With
Set ShEvenement = Nothing
End Sub |
Partager