Forum Discussion
Allign sheet tabs
Hi, I have created sheet1, sheet3,sheet2,sheet4, sheet5 and so on. How to i allign the sheets to sheet 1,2,3,4,5?
Do you mean that you want to sort the tabs in alphabetic order of their name? See How to alphabetize tabs in Excel (works for names ending in 1 ... 9)
Hello,
You can check the link below to guide
https://www.google.com/amp/s/officetricks.com/rearrange-excel-sheets-custom-alphabetic-sort-order-vba/amp/
You can check the link below to guide
https://www.google.com/amp/s/officetricks.com/rearrange-excel-sheets-custom-alphabetic-sort-order-vba/amp/
- I opened the above VBA code, i could see the name as 'settings'...i need a VBA code to rename with the name sheet numbers only....say the order of the sheets now are sheet1,sheet3,sheet2,sheet4,sheet5,sheet7,sheet6....i want those to be realligned to sheet1,2,3,4,5,6&7...please help
