Rename All Sheets From A List... In One Step

There are many ways of renaming sheets in Excel.
However if you have a large number of sheets you can rename all of them in one step following a list in the worksheet itself
In this tutorial I show you how to name any number of Sheets in one step by using a List in the worksheet.

You can Download the Exercise File and the code by clicking on the link here below.

[froidbisebenjamin]

What a great clear video! You explain clearly what you do and what it means. That is what is helping many people to understand!

[sparkleboyd]

THIS WAS I am so glad I found this video Thank you! I was able to follow your instructions and I renamed 23 tabs in a matter of minutes. Much appreciated! God Bless you!!

[alanmclean]

Fantastically clear explanation and helpful visuals that compliment it perfectly. Really helpful for a novice VBA user like me

[elephantsarenuts]

No extraneous chat. Short and directly to the point. Well done.

[vigneshkathirkamar]

Thanks Nabil for this video. I am beginner in vba and your videos are helping me to learn the concepts slowly. Kudos, keep going 🙌

[sheritingle]

Thank you very much for an easy to follow video. Very thankful to have found your channel. GREAT STUFF!!

[gregcalvert]

Stumbled on your channel. Love it, straight to the point useful videos. Thanks BTW, subscribed after the 3rd video.

[kealebogamoletsane]

An excellent video, explained with much clarity and passion, thanks

[michaelshultz]

Thanks - Enjoy your clear explanation of all the details

[ronyshafiq]

I am from bangladesh. I watch many vedio for this problem.. and finally I can say it's simple and very easier then others. Thanks a lot sir

[kamelboukerrou]

Great concise and step by steps instructions. Thank you very much.

[Luciano_mp]

Amazing, very helpful. Thank you Nabil!

[abdulkaderk]

As a specialist teacher, I have to deal with multiple classes. I used to name each sheet as per your introduction. Thank you for this valuable and short method. Since I use all the sheets to insert students names, I named Sheet 1 as YEAR LEVELS created number of sheets according to the number of year levels. Thanking you again.

[mohitjagad]

Thank you Nabil for this amazing tutorial..
Thanks for sharing..👍

[kadirdurma]

You are great man!! it was extremely helpfull and thanks for quick codding tutorial.

[countduckula]

Hi Nabil,
Thank you for posting this extremely useful video.
Your VBA explanation was clear & concise.

[njg]

Worked for me - excellent, thank you.

[suatalturk]

great thank you so much, i helped me a lot with a workbook with more than 200 sheets :)

[ronnie]

when using F8 on the fourth row "Sheet" is highlighted as an error. compiler error message is "variable not defined"
so when defined sheet as worksheets, it worked thanks for the amazing tutorial.

[MdKhan-ccqs]

I do not know abc of VBA. But by this video I am able to rename lot of excel sheets at a single click! Thanks