1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Sub Record()
Dim NbC As Integer, NbP As Integer, j As Integer, m As Integer, n As Integer
Dim NbL As Long, i As Long
Dim Table, Output
Application.ScreenUpdating = False
With Worksheets("(3)data")
NbL = .Cells(.Rows.Count, "A").End(xlUp).Row 'Donne la ligne de la dernière cellule remplie de la colonne A
NbC = .Cells(3, .Columns.Count).End(xlToLeft).Column 'Donne la colonne de la dernière cellule remplie de la ligne 3
Table = .Range(.Cells(4, 1), .Cells(NbL, NbC))
NbL = NbL - 3
NbP = NbC * (NbC - 1) / 2 'Donne le nombre de pair possibles
ReDim Output(1 To NbL, 1 To NbP)
For m = 1 To NbC - 1
For n = m + 1 To NbC
j = j + 1
For i = 1 To NbL
Output(i, j) = Table(i, m) + Table(i, n)
Next i
Next n
Next m
End With
Worksheets("Feuil2").Range("A1").Resize(NbL, NbP) = Output
End Sub |
Partager