Sub Gimme_Five()
[A1:A31].Clear: MsgBox "Test 1": m2025
[A1:A31].Clear: MsgBox "Test 2": m2025
[A1:A31].Clear: MsgBox "Test 3": m2025
[A1:A31].Clear: MsgBox "Test 4": m2025
[A1:A31].Clear: MsgBox "Test 5": m2025
End Sub
Private Sub m2025()
MesJours = Array(20, 21, 22, 23, 24, 25)
Randomize
[A1] = CDate("1-" & Application.RandBetween(1, 12)): [A1:A31].DataSeries
For Each c In Range("A1:A31")
If IsNumeric(Application.Match(Day(c), MesJours, 0)) Then
MsgBox Format(c, "dddd dd mmmm yyyy")
c.Interior.Color = vbMagenta
End If
Next
End Sub