Renaming multiple sheets in a workbook
Closed
rev
-
19 May 2017 à 03:19
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 19 May 2017 à 08:13
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 19 May 2017 à 08:13
Related:
- How to rename multiple sheets in excel at once
- How to rename lg tv - Guide
- How to copy data from one excel sheet to another - Guide
- How to split excel sheet into multiple worksheets - Guide
- Google sheets download - Download - Spreadsheets
- How to delete multiple files at once on mac - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
19 May 2017 à 08:13
19 May 2017 à 08:13
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.
