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 44 45 46 47 48 49 50 51 52
| Sub Macro4()
Sub Macro4()
Dim Periodes, Over, Prod As Integer
Periodes = WorksheetFunction.CountA(Sheets("Parametres").Columns("D:D")) - 1
Over = WorksheetFunction.CountA(Sheets("Parametres").Columns("O:O")) - 2
Prod = WorksheetFunction.CountA(Sheets("Parametres").Columns("A:A")) - 1
If Over = 0 Then
Over = 1
Else
End If
For i = 0 To Prod - 1
Sheets("PARAMETRES").Cells(i + 3, 1).Copy
Sheets("PREPA").Select
Range(Cells(i * Periodes + 1, 6), Cells((i + 1) * Periodes, 6)).Select
ActiveSheet.Paste
Sheets("PARAMETRES").Cells(i + 3, 2).Copy
Sheets("PREPA").Select
Range(Cells(i * Periodes + 1, 8), Cells((i + 1) * Periodes, 8)).Select
ActiveSheet.Paste
Sheets("PARAMETRES").Select
Range(Cells(3, 4), Cells(Periodes + 2, 7)).Copy
Sheets("PREPA").Select
Range(Cells(i * Periodes + 1, 2), Cells((i + 1) * Periodes, 5)).Select
ActiveSheet.Paste
Sheets("PARAMETRES").Select
Range(Cells(3, 8), Cells(Periodes + 2, 8)).Copy
Sheets("PREPA").Select
Range(Cells(i * Periodes + 1, 7), Cells((i + 1) * Periodes, 7)).Select
ActiveSheet.Paste
Sheets("PARAMETRES").Select
Range(Cells(3, 9), Cells(Periodes + 2, 10)).Copy
Sheets("PREPA").Select
Range(Cells(i * Periodes + 1, 9), Cells((i + 1) * Periodes, 10)).Select
ActiveSheet.Paste
Next i
Range(Cells(1, 1), Cells(Prod * Periodes * Over, 1)).Borders.Value = 1
Range(Cells(1, 20), Cells(Prod * Periodes * Over, 20)).Borders.Value = 1
Sheets("PREPA").Cells.Cut
Workbooks.Add
Cells.Select
ActiveSheet.Paste
Sheets("Feuil1").Range("A1").Select
Sheets("Feuil1").Name = "promo"
Application.DisplayAlerts = False
Sheets(Array("Feuil2", "Feuil3")).Delete
Sheets("promo").Select
End Sub
End Sub |
Partager