Turn named table on active worksheet upside down using VBA
I wonder whether it is possible by means of a VBA code to turn a list upside down.
I know the workaround:
- Insert a helper column to the very right.
- Put 1, 2, 3, 4, ... all the way down that column.
- Then select the data and sort by this column in descending order.
- Then delete the helper column.
But now I would like to know how to do this using VBA.
In my special case, I got a named table (MyTable1) on the active worksheet that should be flipped upside down.
Help is much appreciated. Thank you very much in advance.