Rename multiple sheets at once to match cell values in excel
Karina Adcock Karina Adcock
42.5K subscribers
5,323 views
0

 Published On Oct 18, 2023

Sub RenameSheets()
For Each ws in Sheets
ws.Name = ws.Range("A1")
Next ws
End Sub

show more

Share/Embed