Sub essai()
Dim i As Integer
Dim TabTiti(1 To 10, 1 To 1) As Integer
TabTiti(1, 1) = 3
TabTiti(2, 1) = 5
TabTiti(3, 1) = 2
TabTiti(4, 1) = 9
TabTiti(5, 1) = 1
TabTiti(6, 1) = 4
TabTiti(7, 1) = 8
TabTiti(8, 1) = 6
TabTiti(9, 1) = 7
TabTiti(10, 1) = 10
Cells(1, 5).Resize(UBound(TabTiti, 1)) = TabTiti
End Sub