G Guest Feb 15, 2005 #1 I just want the cell to give the title of the sheet. For example: Sheet 1 would be displayed in A2 if A2 had this function.
I just want the cell to give the title of the sheet. For example: Sheet 1 would be displayed in A2 if A2 had this function.
J JE McGimpsey Feb 15, 2005 #2 Take a look here: http://www.mcgimpsey.com/excel/ Matt said: I just want the cell to give the title of the sheet. For example: Sheet 1 would be displayed in A2 if A2 had this function. Click to expand... http://www.mcgimpsey.com/excel/formulae/cell_function.html
Take a look here: http://www.mcgimpsey.com/excel/ Matt said: I just want the cell to give the title of the sheet. For example: Sheet 1 would be displayed in A2 if A2 had this function. Click to expand... http://www.mcgimpsey.com/excel/formulae/cell_function.html
P Peo Sjoblom Feb 15, 2005 #3 One way =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,34) you need to have saved the workbook
One way =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,34) you need to have saved the workbook
