inverse (flip) column of numbers

[VBisgreat]

I have 3 col of number A B and E. I need a macro that can inverse (flip) the numbers in each col.
ex:
1
2
3
4
5
6
7
I need a mcro that flip it so it becomes:
7
6
5
4
3
2
1


Thanks so much

[StephenR]

Why not Sort?

[dominicb]

Good afternoon VBisgreat

I have 3 col of number A B and E. I need a macro that can inverse (flip) the numbers in each col.

Chip Pearson has posted a routine on his website that does just this. You can find it here.

HTH

DominicB

[dominicb]

Why not Sort?

I would suspect that the numbers 1 - 7 are for demonstration purposes only.

DominicB

[martindwilson]

you could just number the rows down then sort descending on those but thats three lots of operation!

[VBisgreat]

Actually, 1-7 is for demonstration purpose only it could be something like this:

2
10
5
7
103
19
then becomes
19
103
7
5
10
2

Thanks all for helping me!!!

[telam445x]

vbisgreat.
Thanks! I have been trying to program my arms off for the same purpose, thanks for the post, and the link to the macro.

[jolivanes]

From Mr DonkeyOte

Please Login or Register  to view this content.

Change Range as required

HTH
John