Function TabName3(cell As Range) TabName3 = cellWorksheetName End Function This version of the function requires that you provide a cell reference—any cell reference—to a cell on the worksheet whose name you want to use Of course, if you would rather not use a userdefined function, you could simply create a macro that would stuff the name of each worksheet tab into the same cellDetails To return the sheet name in a cell, use CELL, FIND and MID in Excel There's no builtin function in Excel that can get the sheet name 1 The CELL function below returns the complete path, workbook name and current worksheet name There are many cases, in which you want to show the sheet name or file name in an Excel cell Don't worry, you don't have to use VBA and create a macro Excel provides a (rough) formula for returning all the information you need The bad news In most cases it takes some complex modifications The good news Usually you can just copy and paste the formula you
Working With Worksheets Using Excel Vba Explained With Examples
