Fire_Chief
Well-known Member
- Joined
- Jun 21, 2003
- Messages
- 693
- Office Version
- 365
- Platform
- Windows
I have some numbers that I put in an array like this:
sub GetNumbers()
range("a1").select
for I = 1 to 10
numbers(I) = activecell
activecell.offset(1,0).select
next I
end sub
Now I want to sort them from highest to lowest.
I have gotten some other code but I don't know how to apply it to my problem and I can't get any other responses.
Thank You
sub GetNumbers()
range("a1").select
for I = 1 to 10
numbers(I) = activecell
activecell.offset(1,0).select
next I
end sub
Now I want to sort them from highest to lowest.
I have gotten some other code but I don't know how to apply it to my problem and I can't get any other responses.
Thank You