View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James8309 James8309 is offline
external usenet poster
 
Posts: 105
Default 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!