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
|
Sub Compilerdonnées1()
Dim Bd As Worksheet, M1 As Object, M2 As Object, M3 As Object, M4 As Object, M5 As Object, M6 As Object, M7 As Object, M8 As Object, M9 As Object, M10 As Object, M11 As Object, M12 As Object
Dim SourceOnglet As Variant
Dim x As Integer, y As Integer
Set Bd = Worksheets("Bd")
Set M1 = Worksheets("SEPT").[SEPT]
Set M2 = Sheets("OCT").[OCT]
Set M3 = Sheets("NOV").[NOV]
Set M4 = Sheets("DEC").[DEC]
Set M5 = Sheets("JANV").[JANV]
Set M6 = Sheets("FEV").[FEV]
Set M7 = Sheets("MARS").[MARS]
Set M8 = Sheets("AVRIL").[AVRIL]
Set M9 = Sheets("MAI").[MAI]
Set M10 = Sheets("JUIN").[JUIN]
Set M11 = Sheets("JUILLET").[JUILLET]
Set M12 = Sheets("AOUT").[AOUT]
x = 1
For Each SourceOnglet In Array("SEPT", "OCT", "NOV", "DEC", "JANV", "FEV", "MARS", "AVRIL", "MAI", "JUIN", "JUILLET", "AOUT")
With ThisWorkbook.Worksheets(CStr(SourceOnglet))
For y = 1 To 12
'erreur ici lorsque j'aimerais appellé la première variable, puis les autres
M & "x".Copy Bd.[B4].End(xlDown).Offset(1, 0)
x = x + 1
Next y
End With
Next
End Sub |
Partager