Can someone help me sort sheets according to Transaction Type (Column N) using one VBA code that applies to all worksheets, which have variable number of rows? In ascending order and has fixed column up to CV. PS. Newbie in VBA but willing to learn.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,974
- Office Version
- 365
- Platform
- Windows
The only thing that Macro Recorder won't record here is a loop to go through all your sheets.
Here is a link that shows you how to do that. Just place your recorded code inside the loop.
https://support.microsoft.com/en-us/help/142126/macro-to-loop-through-all-worksheets-in-a-workbook
Note that you will either need to select each sheet within the loop (ws.Activate) first, or include the worksheet reference in all ranges in order to apply that code to the appropriate sheet as it is looping through.
Here is a link that shows you how to do that. Just place your recorded code inside the loop.
https://support.microsoft.com/en-us/help/142126/macro-to-loop-through-all-worksheets-in-a-workbook
Note that you will either need to select each sheet within the loop (ws.Activate) first, or include the worksheet reference in all ranges in order to apply that code to the appropriate sheet as it is looping through.
Upvote
0
