Forum Discussion

Marco90's avatar
Marco90
Copper Contributor
Mar 03, 2020

Rename sheets

Hi, How do I manage all the sheets in the folder in progressive order? Thank you!
excel
Marco90's avatar
Marco90
Copper Contributor
Mar 03, 2020
I have to rename the sheets’s labels in the folder progressively ex: 1,2,3...
Is there an instruction? 🤔
Savia's avatar
Savia
Iron Contributor
Mar 03, 2020
You can use this VBA code:

Sub SheetNamer()

For i = 1 To ActiveWorkbook.Sheets.Count
Sheets(i).Name = i
Next i

End Sub

Resources