Re ordering help urgent!!!

J

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!
 
B

Bob Bridges

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reverse pasting rows with alternate blank cells 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
code snippet below. Is there a shorter way to do this type of thin 6
simple code but it doesn't look like usual vba code 2
Find the rightmost value 5
Permutations andText to column problem 6
Produce Random Numbers 6

Top