Hello,
I would like to automatically change a tab's name to whatever the value is in cell A1 on that same sheet. I found the Excel Forum thread below that provides a solution for this:
https://www.excelforum.com/excel-for...d-formula.html
In this thread, the following code is used to make this happen:
I know I am a total VBA noob, but this seems pretty simple and self explanatory, but for the life of me I cannot get it to work.
Please Login or Register to view this content.
Thanks.
A1 contains a date which evaluates to a string containing the "/' y,m,d, separators. That's an invalid character for a sheet name.
Use
Sheet100.Name = Format(Range("A1").Value, "mmmm yyyy")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard you are an Excel saint!!
That did the trick. Holy cow, did I go round and round with that sucker.
Many thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks