How do you display the sheet name in a cell?
J Jason Morin Jan 18, 2005 #2 =MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,31) Workbook must be saved to work. HTH Jason Atlanta, GA
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,31) Workbook must be saved to work. HTH Jason Atlanta, GA