What's the formula to put the sheet name into a cell? Thank you, MB
P Peo Sjoblom Apr 4, 2005 #2 Workbook needs to be saved first =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,34)
J JE McGimpsey Apr 4, 2005 #3 take a look here: http://www.mcgimpsey.com/excel/formulae/cell_function.html
