Renaming multiple sheets in a workbook
Closed
rev
-
May 19, 2017 at 03:19 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - May 19, 2017 at 08:13 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - May 19, 2017 at 08:13 AM
Related:
- Renaming multiple sheets in a workbook
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- How do you auto populate data from multiple sheets to a master? ✓ - Excel Forum
- Multiple functions in one cell - Excel Forum
1 reply
vcoolio
Posts
1364
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 10, 2023
252
May 19, 2017 at 08:13 AM
May 19, 2017 at 08:13 AM
Hello Rev,
Have a look at the following link:-
https://ccm.net/forum/affich-419062-excel-macro-rename-all-worksheets
If you want to add the workbook name, you'll only need to adjust this line:-
For example, if your workbook is named Fred, then alter the line as follows:-
Your worksheet tabs should then look like this:-
"Fred, Sheet1", "Fred, Sheet2" etc......
Cheerio,
vcoolio.
Have a look at the following link:-
https://ccm.net/forum/affich-419062-excel-macro-rename-all-worksheets
If you want to add the workbook name, you'll only need to adjust this line:-
Sheets(iSheetCount).Name = iSheetCount
For example, if your workbook is named Fred, then alter the line as follows:-
Sheets(iSheetCount).Name = "Fred, Sheet" & iSheetCount
Your worksheet tabs should then look like this:-
"Fred, Sheet1", "Fred, Sheet2" etc......
Cheerio,
vcoolio.
