You don't want to just sort them, using Excel Data.Sort or (since this is the
Programming forum) the Range.Sort method?

--- "James8309" wrote:
- From number 1 to 13 ( i.e. 1,2,3,4,5,6,7,8,9,10,11,12,13), five
numbers gets picked randomly and gets placed from range("A1:E1") in
order that they got picked.

e.g. if I picked 5 - 1 - 13 - 2 - 9 then
A1 = "5"
B1 = "1"
C1 = "13"
D1 = "2"
E1 = "9"

- How do I make them arranged from small to large automatically (i.e.
1 being the lowest 13 being the largest) so above example will change
the orders and put the correct order into range("F1:J1")
i.e.

F1 = "1"
G1 = "2"
H1 = "5"
I1 = "9"
J1 = "13"