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
| Sub Test()
Set Coll_NumCommande = New Collection
x = -1
With Worksheets("Base_Utile")
DerLigne = .Range("A1048576").End(xlUp).Row
DerCol = .Range("X1").End(xlToLeft).Column
Tabtemp = .Range(.Cells(2, 1), .Cells(DerLigne, DerCol))
On Error Resume Next
For L = 1 To UBound(Tabtemp, 1)
Coll_NumCommande.Add Tabtemp(L, 1), CStr(Tabtemp(L, 1))
If Err.Number = 0 Then
x = x + 1
ReDim Preserve TabRecap(24, x)
For Col = 1 To UBound(Tabtemp, 2) - 1
TabRecap(Col - 1, x) = Tabtemp(L, Col)
Next
For LL = 1 To UBound(Tabtemp, 1)
If Tabtemp(LL, 1) = Tabtemp(L, 1) Then
TabRecap(Col - 1, x) = TabRecap(Col - 1, x) + Tabtemp(LL, UBound(Tabtemp, 2))
End If
Next
End If
Err.Clear
Next
On Error GoTo 0
.Range(.Cells(2, 1), .Cells(DerLigne, DerCol)).ClearContents
DerLigne = .Range("A1048576").End(xlUp).Row + 1
.Cells(DerLigne, 1).Resize(UBound(TabRecap, 2) + 1, UBound(TabRecap, 1)) = Application.Transpose(TabRecap)
End With
End Sub |
Partager