BInterest

How to auto rename excel worksheet tabs to specific cell via VBA code or macro ? There is not official way / ribbon button / function to auto rename all the tabs in excel workbook as per contain of specified cell within that sheet. Renaming the tabs of the excel workbook is must for the better understandably & usability within a team or when your working sheet has to be used by someone else in the company.

Rename Worksheet Tab – Excel VBA Macro Code :

Note : The cell values on each sheet should not be null and should be unique in the workbook since no two sheets can have the same name.

Sub RenameTabs()
' Renames all worksheet tabs with each worksheet's cell A1 contents.
'If cell A1 has no content, then that tab is not renamed.

For i = 1 To Sheets.Count
If Worksheets(i).Range("A1").Value <> "" Then
Sheets(i).Name = Worksheets(i).Range("A1").Value
End If
Next
End Sub

Rename Worksheet Tab – Excel VBA Macro Code :

Note : The cell values on each sheet can be null and should be unique in the workbook via using If – Else Function within this Rename Worksheet Tab VBA Code.

Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs with each worksheet's cell A1 contents.
'If cell A1 has no content, then the tab is named as "Default"

For i = 1 To Sheets.Count
If Worksheets(i).Range("A1").Value <> "" Then
Sheets(i).Name = Worksheets(i).Range("A1").Value
Else:
Sheets(i).Name = "Default (" i &amp; ")"
End If
Next
End Sub

You can change the desired cell which would replace the worksheet tab name from A1 to any other Cell like B2 for all the ORG IMS SSA Output. You can save this VBA Code as a macro for later use as separate sheet or macro on this computer. If you don’t like to make your copy of the macro, here is my copy of the rename tab excel Macro sheet, which you can download & Use it.

Don’t forget to tell via comment, how helpful is this type of post on excel macro in your office use, so that I could provide you with some more tricks which i use on the daily basis.

You can follow me on Twitter at http://twitter.com/binterest.Do stay tuned to Binterest.com for more, Best Way 2 do it, Subscribe to Binterest's Feed Updates