Excel loop - Renaming sheet tabs from range

Good night everyone,

I've created a macro that renames a tab but it is very basic.

Please Login or Register  to view this content.

I have Sheet1 named as "Pictures". This sheet has a macro button on it and I do not want this sheet name to change. When I click the button, I am looking to have sheet2 and onwards be renamed after the data in range A2:A18. The ranges consist of picture names and I would like the tabs to be names accordingly and stop the loop if there is a blank (no data in the cell).

Any help would be greatly appreicate.

Thanks

I think you want to change your sheets such as sheet2.name = A2, sheet3.name = A3 and etc, don't you? Here it is your code.

Please Login or Register  to view this content.

Hi Gervie,

You are correct. I just want to rename the sheet tabs that I already have existing.

When I entered your code, nothing change. The msgbox appeared but none of the tabs updated.

Please help.

Actually, I made a error and it worked! Your code worked amazing Gervie. If I wanted to skip naming sheet2 but Sheet3 and so forth, is there a way to adjust the code to do that?

Thanks so much.

You should change your code to below code. Because if you used my old code, it would be stopped when errors appeared.

Please Login or Register  to view this content.

If you want to skip naming the second sheet, you can change it to:

Please Login or Register  to view this content.

Work great. Thanks so much for the help. I appreciate it