troubleshooting Question

Turn named table on active worksheet upside down using VBA

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
Microsoft Excel
7 Comments2 Solutions478 ViewsLast Modified:
Dear Experts:

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.

Regards, Andreas
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros