Re ordering help urgent!!!
 

Hi everyone,

- 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"

Thank you for your help in advance!

Re ordering help urgent!!!
 

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"