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?
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