Sub cree_un_onglet_jour()
Dim nj As Long
Dim i As Byte
Mois = InputBox("Saisir numéro du mois (1 à 12)")
ladate = DateValue("1/" & Mois & "/" & Year(Date))
nj = Day(DateAdd("d", -1, DateAdd("m", 1, DateSerial(Year(Date), Mois, 1))))
For i = 1 To nj
ActiveWorkbook.Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name = _
Format(DateValue(i & "/" & Format(ladate, "mm/yy")), "dd-mm-yy")
Next i
End Sub
Sub copie_un_onglet_jour()
Dim nj As Long
Dim i As Byte
Mois = InputBox("Saisir numéro du mois (1 à 12)")
ladate = DateValue("1/" & Mois & "/" & Year(Date))
nj = Day(DateAdd("d", -1, DateAdd("m", 1, DateSerial(Year(Date), Mois, 1))))
Application.ScreenUpdating = False
For i = 1 To nj
Sheets("Feuil1").Copy After:=Sheets(i)
ActiveSheet.Name = _
Format(DateValue(i & "/" & Format(ladate, "mm/yy")), "dd-mm-yy")
Next i
Application.ScreenUpdating = True
End Sub