Sheet tabs & cells

  • Thread starter Thread starter Guest
  • Start date Start date
Exactly what I needed, thanks.

David McRitchie said:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

The CELL formulas with "filename" will not work until the file has been saved (#VALUE! error).

for more information see
Pathname in headings, footers, and cells
http://www.mvps.org/dmcritchie/excel/pathname.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"RJReese" wrote...
Is there a way to display sheet tab text in a cell?
Click to expand...
Click to expand...
 
Back
Top