Hi all,

I am an absolute beginner on Macros and have barely made my first coding work (thanks to this forum).

I wanted to name Sheets automatically which with below code works so long there's a name in the sheet in cell A1.

Sub PortfolioUpdate()

Dim rs As Worksheet

For Each rs In Sheets
rs.Name = rs.Range("A1")
Next rs

End Sub
Problem is that if I add a new sheet and forget to put a name in A1 the code doesn't work, and I only want the automatic naming to occur for specific sheets.
All these sheets I want to be named automatically are between sheets named "Start" and "End" - meaning all the sheets in between "Start" and "End" I would want to have their names updated as the code above does, but for any sheet that falls outside of this range the name should remain unchanged.

Hopefully my request is clear enough and any help is greatly appreciated.

Many thanks
Lucas