Sorting a range to invert it upside down without sorting by any specific column

I have a bunch of data in A1:D20. Is it possible to sort it with VB without using any particular column in the worsheet to sort it by so that the data basically turns upside down. That is - row 1 data now appears in row 20, row 2 data in row 19, row 3 in row 18 and so on? I'm looking to do this without adding an additional column and numbering it 1:20, then sorting it by that column.

Thank you

Is this same question?

http://www.excelforum.com/excel-form...ic-column.html

Mick,

That works great! Thank you!

Fotis - yes and no - I wanted to learn how to do it with and without VBA as I have different applications for each method.

PLs be carefull when you do this, because in fact it's a duplicate thread. It's better to make a notice that you would like suggestions for both ways.

Mick (or anyone else that has any advice),

Your code below works great for when my data starts in cell A1, though that's not always the case - C4, R22, T90 you name it. I tried tweaking it to make it work, but never seem to get it to do the operation correctly. Any advice?

Please Login or Register  to view this content.

Thanks.

Fotis, no problem - will do.