A voir
Sub test()
With ThisWorkbook.Worksheets("Feuil1")
.Range("D1:BD1").Formula = "Sem"
J = 1
For i = 4 To 56
Cells(1, i).Value = Cells(1, i).Value & " " & J
J = J + 1
Next i
.Range("A4:A200000").Formula = "Dossier"
Cells(2, 1) = "Dossiers"
Range("A2").Font.Bold = True
Cells(1, 2) = "Semaines"
Range("B1").Font.Bold = True
End With
End Sub
Re, voir plus court
Sub test()
Dim i%, J%
With ThisWorkbook.Worksheets("Feuil1")
J = 1
For i = 4 To 56
Cells(1, i).Value = "Sem " & J
J = J + 1
Next i
.Range("A4:A200000").Formula = "Dossier"
Cells(2, 1) = "Dossiers"
Range("A2").Font.Bold = True
Cells(1, 2) = "Semaines"
Range("B1").Font.Bold = True
End With
End Sub