Sub test()
Dim tbl(1 To 10, 1 To 8), I&, C&, X&, col&, Lig&
For I = 1 To 10
For C = 1 To 8
X = X + 1
tbl(I, C) = X
Next
Next
For I = 1 To 10
For C = 1 To 8
Lig = Int(1 + (Rnd * 9))
col = Int(1 + (Rnd * 7))
tmp = tbl(I, C): tbl(I, C) = tbl(Lig, col): tbl(Lig, col) = tmp
Next
Next
[u6].Resize(10, 8) = tbl
End Sub