Bonjour,
Sub CombiDistances()
Dim TD(1 To 4), Tbl(), i%, a%, b%, c%, d%
For i = 1 To 4
TD(i) = Worksheets("Distance " & i).Range("B2:B11").Value
Next i
ReDim Tbl(9999, 1 To 4): i = 0
For a = 1 To 10
For b = 1 To 10
For c = 1 To 10
For d = 1 To 10
Tbl(i, 1) = TD(1)(a, 1)
Tbl(i, 2) = TD(2)(b, 1)
Tbl(i, 3) = TD(3)(c, 1)
Tbl(i, 4) = TD(4)(d, 1)
i = i + 1
Next d
Next c
Next b
Next a
Worksheets("Variant combination").Range("B2").Resize(10000, 4).Value = Tbl
End Sub
Pas vraiment optimisé, mais 10000 combinaisons, cela reste un nombre relativement réduit.
edit: Salut h2so4 !