•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Correct VBA format for changing multiple sheet tab names in a workbook
Hello!
I am trying to change several worksheet tab names. From Googling I see that I can use a VBA to batch change an entire workbook's tabs. I'm not sure what language to use to execute this change successfully.
I have designed a planner that I intend to print out. Name format is: Month Date - Left/Right (depending on which side of the binder the page will sit when open). I want to change "April" to "May." (An individual workbook for each month of the year.)
How would I set the VBA up to rename each of the tabs?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#google sheets