To create a named cell in Microsoft Excel, select the cell and click the Name Box next to the formula bar, as shown in the image This bar has the current cell location printed in it For example, if you're in cell A1, it should currently say A1 in the Name Box In the Name Box, type the name you want to name the cell and press EnterActiveSheetName = ActiveSheetRange ("A1") End If End Sub Note In the code, A1 is the cell which contains the value you need to use as sheet name You can change it as you need From now on, when the value in cell A1 changed, the sheet tab name will be changed equally as wellTo 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 Note instead of using A1, you can refer to any cell on the first worksheet to get the name of this worksheet
Vba Rename Sheet How To Rename Sheet In Excel Using Vba
