Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-22-2024, 06:43 AM
Dr. Rick Dr. Rick is offline VBA/Macro to reverse order table lines Windows 10 VBA/Macro to reverse order table lines Office 2010
Advanced Beginner
VBA/Macro to reverse order table lines
 
Join Date: Apr 2023
Location: Coastal N.C.
Posts: 32
Dr. Rick is on a distinguished road
Thumbs up

Quote:
Originally Posted by gmaxey View Post
You don't need a macro to do this.


1. Add your temporary column
2. Define the order you want the rows indexed
3. Sort the table on the temporary column
4. Remove the temporary table

It's true, Greg, that I might not NEED a macro for this, but isn't the whole purpose of macro to automate tasks? I'm NOT trying to sound whiny or snarky. I tried the above process and no doubt did something wrong and it didn't produce the results I wanted, so I'm taking the lazy way out and wanting someone else to give me a macro that will accomplish it.


Thanks, however, for confirming that I had the right idea.


I'm sure there must be a way I can do those 4 steps from the keyboard--I'm still trying to get over the fact that one can't include mouse clicks in macros. I was sure I had done so in the distant past when recording a macro, but I was told authoritatively that this probably was not so.


Thanks, anyway. I'll try the hammer and tongs method again and see what happens.
Good day.
RJ
Reply With Quote
 

Tags
order of tables, reversing order



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA/Macro to reverse order table lines Print two pages per page but in reverse order hammad Word 10 06-20-2019 09:01 AM
reverse order of paragraphs, word 2010 moorea21 Word VBA 1 08-02-2018 03:47 AM
VBA/Macro to reverse order table lines Is There an Animation that Will Reverse the Order of a Bulleted List equity PowerPoint 3 04-04-2014 12:33 AM
VBA/Macro to reverse order table lines Reverse Order for Flashcards? bknollman3 PowerPoint 2 03-23-2013 06:34 AM
Reverse order of headings throughout Word my_vine_figtree Word VBA 1 08-17-2010 01:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft