Rename worksheet based on cell value

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,

Are the 'Start' and 'End' Sheets called 'Start' and 'End'?
Are they the only Sheets to exclude?

Does

Please Login or Register  to view this content.

make a difference?

Maybe:

Please Login or Register  to view this content.

There is a Start and End tab. All of the sheets that fall in between I am looking to rename.

Modified per Post#4.

Please Login or Register  to view this content.