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
| Sub Cree_Feuilles()
Dim i As Integer
Dim Last_line As Integer
Dim Feuille As Worksheet
With Worksheets("CIRC CLT")
Last_line = .Columns(5).Find("*", , , , , xlPrevious).Row
For i = 14 To Last_line
If Not IsNumeric(.Cells(i, 5).Value) And .Cells(i, 5).Value <> "" Then
If Not SheetExists(.Cells(i, 5).Value) Then
Worksheets("Base").Range("A1:E49").Copy
Set Feuille = Sheets.Add(After:=Sheets(Sheets.Count))
Feuille.Name = Worksheets("CIRC CLT").Cells(i, 5).Value
Feuille.Paste
Application.CutCopyMode = False
With Feuille
.Cells(1, 5) = (Worksheets("CIRC CLT").Cells(i, 5).Value)
.Columns(1).ColumnWidth = 17.57
.Columns(2).ColumnWidth = 14.14
.Columns(3).ColumnWidth = 36.71
.Columns(4).ColumnWidth = 17.86
.Columns(5).ColumnWidth = 17.86
End With
End If
End If
Next i
End With
End Sub |