Sub test()
MsgBox Join(TriFoutoir(Array(1, 2, 3, 4, 5)), vbCr)
End Sub
Function TriFoutoir(ByVal TB)
Dim C As New Collection, ID As Integer, I As Integer
For Each T In TB
C.Add T
Next
Randomize Timer
For I = LBound(TB) To UBound(TB)
ID = Int(C.Count * Rnd + 1)
TB(I) = C(ID)
C.Remove ID
Next
TriFoutoir = TB
End Function