[COLOR="DarkSlateGray"]Sub ZERO_DOUBLON_PAR_LIGNE()
Dim oDat(), sDat(), i As Long, j As Long, k As Long
oDat = Range("C7:C20").Value
ReDim sDat(1 To 5, 1 To 4)
Randomize
For i = 1 To 5
For j = 1 To 4
k = j + Int((15 - j) * Rnd)
sDat(i, j) = oDat(k, 1): oDat(k, 1) = oDat(j, 1): oDat(j, 1) = sDat(i, j)
Next j
Next i
Range("M3:P7").Value = sDat
End Sub[/COLOR]