Worksheet name, workbook name, filename

Get name file from complete name file (C:\WINDOWS\TXT\Chapter\ text03.txt)

Name of the current workbook can be accessed using the CELL().

If you change the sheet name, all references in formulas will automatically update and will continue to work. The exception is the function the INDIRECT(), in which the sheet name can appear in text form INDIRECT("Sheet1!A1"). This article shows you how to use the function CELL() to save the health formula with the function the INDIRECT().

Define the worksheet name using the function CELL().