Changing Selected Tab Names Based On Cell Value
Hi All,
I have a workbook with 24 sheets. Of the 24 sheets 12 need to have the tab names changed to reflect the month showing in cell B1.
The code I have been trying to adapt is below. The line which throws up an error is highlighted in red. Also, there appears to be missing code needed to insert the new name into the tab and taken from cell B1 on each sheet.
Any help or pointers would be appreciated.
Thanks in advance.
Please Login or Register to view this content.
That line of code is not doing anything.
Possibly something like:
Please Login or Register to view this content.
Thanks for trying but I've just tried it and there is still an error being thrown up, unfortunately.
Last edited by Togora; 08-23-2019 at 05:14 PM. Reason: Spelling error, sorry.
! Code in post 2 does work...What error is it throwing...I am assuming that one of your sheet names in array are incorrect...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks