Marco90Copper ContributorMar 03, 2020Rename sheetsHi,How do I manage all the sheets in the folder in progressive order?Thank you!
3 RepliesReplies sorted by NewestSaviaIron ContributorMar 03, 2020Can you explain what you mean a bit more?Marco90Copper Contributor to SaviaMar 03, 2020I have to rename the sheets’s labels in the folder progressively ex: 1,2,3...Is there an instruction? 🤔SaviaIron Contributor to Marco90Mar 03, 2020You can use this VBA code:Sub SheetNamer()For i = 1 To ActiveWorkbook.Sheets.CountSheets(i).Name = iNext iEnd Sub
Marco90Copper Contributor to SaviaMar 03, 2020I have to rename the sheets’s labels in the folder progressively ex: 1,2,3...Is there an instruction? 🤔
SaviaIron Contributor to Marco90Mar 03, 2020You can use this VBA code:Sub SheetNamer()For i = 1 To ActiveWorkbook.Sheets.CountSheets(i).Name = iNext iEnd Sub
