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
| Public Sub ListerCombinaisons()
Dim n As Integer
Dim p As Integer
n = 8
p = 3
Dim tableau(8 ^ 3, 3) As Integer
Dim i As Integer
Dim j As Integer
For i = 1 To p
tableau(1, i) = 1
Worksheets("Feuil1").Range(Chr(64 + i) & 1).Value = tableau(1, i)
Next
Dim Add As Integer
Add = 0
For i = 2 To 9
For j = 1 To p
If (tableau(i - 1, j) = n) Then
tableau(i, j) = 1
tableau(i, j - 1) = tableau(i - 1, j - 1) + 1
Else
tableau(i, j) = tableau(i - 1, j)
End If
Worksheets("Feuil1").Range(Chr(64 + j) & i).Value = tableau(i, j)
Next
Next
End Sub |
Partager