You can also use an Excel VBA Macro to quickly get a list of all worksheet tab names in your workbook Just do the following steps #1 open your excel workbook and then click on " Visual Basic " command under DEVELOPER Tab, or just press " ALTF11 " shortcut #2 then the " Visual Basic Editor " window will appearYou can use below code to get the Active Sheet name and change it to yours preferred name Sub ChangeSheetName () Dim shName As String Dim currentName As String currentName = ActiveSheetName shName = InputBox ("What name you want to give for your sheet") ThisWorkbookSheets (currentName)Name = shName End SubA VBA function like Function SheetName(ByVal Index As Long, Optional ByVal Book as Range) as String ApplicationVolatile If Book Is Nothing Then Set Book = ApplicationCaller SheetName=BookWorksheetParentSheets(Index)Name End Function would return sheet names by index, like an Excel formula Example
How To Get Sheet Name In Excel Vba Excel Tutorials
