I have a workbook with a lot of sheets .
My goal is to rename all sheets based on cell value of cells A2 for each sheet in the workbook.
That is sheets 1 cells A2 reads GAMMA , then sheet rename gamma, then sheets 2 cell A2 reads alpha then sheet alpha but sometimes some sheets may have same name in cells A2(gamma) then rename gamma_1
Looking a macro that can perform this tasks
Please Login or Register to view this content.
Last edited by JLGWhiz; 10-13-2019 at 01:12 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
This will handle duplicate A2 values and illegal names in A2
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank you both works great as expected
Last edited by JEAN1972; 10-13-2019 at 02:56 PM. Reason: typo
Happt to assist. Thanks for the reps. Don't forget to mark the thread as solved.
Regards, JLG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks