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 39 40 41 42 43
|
Sub Macro1()
Dim I As Long
Dim B As Long
Dim Debut As Long
Dim Fin As Long
For I = 1 To 365
Feuil1.Range("A1:I24").Copy Feuil1.Range("A" & I * 24 + 1)
Next I
Application.CutCopyMode = False
B = 1
Debut = Range("Feuil2!A1")
Fin = Range("Feuil2!A2")
With Worksheets("Feuil1")
For I = Debut To Fin
Select Case Weekday(I, vbMonday) 'le lundi n°1 de la semaine
Case 1 To 5 'du lundi au vendredi
Worksheets("Feuil1").Cells(B, 7) = "97V" & _
Format(Day(I), "00") & _
Format(Month(I), "00") & _
Right(Year(I), 2) & "E1"
B = B + 24
End Select
Next
End With
End Sub |
Partager