Hello,
I used the below to rename tabs in my excel file, but it renames every sheet with the specific cell number. I would like to only rename tabs that fall within my start and end sheets. Any help?
Sub UpdateSheetNames()
On Error Resume Next
For Each ws In Worksheets
ws. name = ws.range("A2").Text
Next ws
End Sub
Thanks,
Bookmarks