Renaming multiple sheets in a workbook
Closed
rev
-
May 19, 2017 at 03:19 AM
vcoolio
vcoolio
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
Related:
- Renaming multiple sheets in a workbook
- Excel vba rename multiple sheets based on cell value - Forum - Excel
- I want to retrieve value from multiple sheets of same workbook ✓ - Forum - Excel
- Excel Macro: Rename all Worksheets ✓ - Forum - Excel
- Vba copy multiple sheets to new workbook ✓ - Forum - Excel
- Vba copy multiple sheets to new workbook as values ✓ - Forum - Excel
1 reply
vcoolio
May 19, 2017 at 08:13 AM
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
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.