Automatically name sheet within range

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.

Please Login or Register  to view this content.

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

Hi & welcome to the board
How about

Please Login or Register  to view this content.

You are the name, that works like a charm.

Thanks a lot for your help!

/Lucas

You're welcome & thanks for the feedback