Please bear with me if I'm not clear with my question. This is my first post...
I have a template that each time used, there are 60 tabs that need to be renamed. There need to be twenty named name1.R, name2.R, etc., twenty named name1, name2, etc., and twenty named name1.V, name2.V, etc. I have a setup worksheet that has a list of all the base names. Is there a way I can use that to create a code to rename all? Thanks!
Possibly...
Please Login or Register to view this content.
This could be the answer, but I'm honestly not sure. So, let me give more specific info.
I have a sheet named "Setup". On the sheet is a list of the names for the tabs. I do need specific sheets to be named specific names. The first three sheets and the final sheet will never need to be renamed. There may be a much better way to do this, but the attached spreadsheet contains my list of names, as well as which sheet should be named what. I have it set up so that I plug in the part of the name that changes each time and it generates what the tab name should be (either just the name, the name.R or the name.V.
Sorry if your code will address my question and I'm just not seeing it. Maybe I just need more specific direction in how to apply it. Thanks!
Last edited by abq_jessica; 08-31-2020 at 04:15 PM. Reason: added attachment
Try this on a copy of the file...Please Login or Register to view this content.
Hi, nope! It hits and issues at "Sheets(v(i, 2)).Name = v(i, 1)". Thanks!
Can you give a better explanation of "hits and issues" ?
Sorry, typo. I meant hits an issue (error).
You can loop through the sheet's code names then rename the sheet accordingly.
Please Login or Register to view this content.
What is the error?Originally Posted by abq_jessica
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks