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
Savia's avatar
Savia
Iron Contributor
Mar 03, 2020
Can you explain what you mean a bit more?
  • 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