Excel Macro: Rename all Worksheets
Solved/Closed
So, I'm trying to figure out a way to rename all the worksheets in a workbook.
the first worksheet would be "1" (without the quotation marks) and continue up for each worksheet, so the second worksheet would be 2, the third worksheet 3, etc.
any help will be much appreciated.
thanks
the first worksheet would be "1" (without the quotation marks) and continue up for each worksheet, so the second worksheet would be 2, the third worksheet 3, etc.
any help will be much appreciated.
thanks
Related:
- Excel vba rename sheet
- Rename computer cmd - Guide
- Rename lg tv - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
- Sheet right to left in google sheet - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 9, 2010 at 04:50 PM
Jul 9, 2010 at 04:50 PM
Sub renameSheets() Dim iSheetCount For iSheetCount = 1 To Sheets.Count Sheets(iSheetCount).Name = iSheetCount Next iSheetCount End Sub
Jul 9, 2010 at 06:05 PM
Jan 23, 2011 at 03:11 PM
Nov 3, 2011 at 06:30 AM
Apr 24, 2013 at 08:50 AM
Sep 4, 2013 at 08:54 AM