Re ordering help urgent!!!

[James8309]

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!

 

[paulgu]

In VBA, copy the range A1:E1, paste it into F1:J1, then sort the range F1:J1. If not sure how to do this in VBA, record a new macro and do it "manually".