Use This Trick to Rename Multiple Excel Worksheets

preview_player
Показать описание
Use this trick to rename multiple Excel worksheets. Renaming worksheets in Excel is a drag. Don't worry, there is a solution.

Follow the simple steps in this video Excel tutorial and learn how to rename multiple Excel worksheets instantly.

Here is the code used in the video (Please note, the description doesn't allow me to type less than and greater than brackets). Please enter them before the "" in the code):

Sub Rename()
Dim r As Integer
r = 1

For Each Sheet In Sheets
If Cells(r, 1) "" Then
Sheet.Name = Cells(r, 1).Value
r = r + 1
End If
Next

End Sub

If you are interested in more information about Excel then I highly recommend the channel @Microsoft

#exceltutorial #exceltips #usemybox

Remember to subscribe to Usemybox for computer how to videos in Excel, Word, Powerpoint, Windows, internet browsers and more.

Subscribe for More IT & Software How To Videos:
Рекомендации по теме
Комментарии
Автор

How do i multi rename sheets like if i have a sheets from 1 jan to 31 jan and i want to change them to february

motheteletshepo
Автор

Can you try to paste the full formula in the comments here? I am getting the same error of “run-time error ‘1004” need assistance please!

Hairjourney_vlh
Автор

FYI you need to put the names of the tabs you want into the sheet you're saving as the macro. You also have to have the same amount of tabs as the number of names. Eg if you want tabs for the months of the year, you need 12 tabs at the bottom.

not sure if i could get this to work with pre populated worksheets with sh1tloads of data.

essellohbeebeewhy
Автор

I get a syntax error in the "If Cells(r, row, please help

b-sahilkesanakurty
Автор

Hi, it says "Run-time error '1004': you typed an invalid name for a sheet or chart" what does it mean?

x.mntrob
Автор

how do i remove all the spaces in the sheet names

remoherewidsumcarrots
Автор

Getting syntax error in the first line :(

purvidaga