Sub test()
Dim i As Date, x As Byte, y As Byte, z As Byte
For i = DateSerial(Year(Date) - 1, 7, 1) To DateSerial(Year(Date), 6, 30)
x = DatePart("ww", i, 2, 2)
If x <> y Then
y = x
z = z + 1
Sheets(z).Name = "SEM_" & Format(x, "00") & "-" & MonthName(Month(i)) & "-" & Year(i)
End If
Next i
End Sub
bonne journée.
@+