Is it possible to rearrange the sheets on the numbers of the tabs.
I want to have the sheet with the lowest number of the tab on the left to start with.
Is it possible to rearrange the sheets on the numbers of the tabs.
I want to have the sheet with the lowest number of the tab on the left to start with.
check here for more details..
http://www.ozgrid.com/VBA/sort-sheets.htm
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi Jos,
There's plenty of references on how to do this on the internet including this article by Pearson Software Consulting.
That said, I wrote this to sort numeric sheet tabs as in your example as well:
Regards,![]()
Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Thanks, everybody.
This works for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks