Bonjour
essaies en remplaçant
Dim cel As Range
For Each cel In Range('A1:A5000')
If cel.Value = 'Absents' Then
Range('A1:A' & cel.row).Select
Selection.Delete Shift:=xlUp
End If
Next
essaies même en supprimant le select
Dim cel As Range
For Each cel In Range('A1:A5000')
If cel.Value = 'Absents' Then
Range('A1:A' & cel.row).Delete
End If
Next