Bonsoir
bon voila le dernier
Sub TestDate()
Dim Nlig&, L&, C&, C1&
Application.ScreenUpdating = False
Jlig = F00.Cells(Rows.Count, 2).End(xlUp).Row
Columns("H:H").Select
Range(Selection, Selection.End(xlToRight)).Clear
Nlig = Cells(Rows.Count, 7).End(xlUp).Row
For L = 2 To Nlig
C1 = 7
For C = Range("G" & L).Value2 To Range("F" & L).Value2
Cells(L, C1).Value = C
Cells(L, C1).NumberFormat = "m/d/yyyy"
Select Case Weekday(DateSerial(Year(Cells(L, C1)), Month(Cells(L, C1)), Day(Cells(L, C1))))
Case 1, 7
Cells(L, C1).Clear
C1 = C1 - 1
' Cells(L, C1).Interior.ColorIndex = 24 '15
End Select
For T = 2 To Jlig
If DateSerial(Year(Cells(L, C1)), Month(Cells(L, C1)), Day(Cells(L, C1))) = F00.Range("C" & T).Value Then
Cells(L, C1).Clear
C1 = C1 - 1
' Cells(L, C1).Interior.ColorIndex = 45 '4 '3 '6
End If
Next
C1 = C1 + 1
Next
Next
MsgBox "Terminer"
Application.Goto [A1], True
End Sub
je pense que ca doit aller
A+
Maurice