Posted to microsoft.public.excel.misc
|
|
Sheet tabs & cells
Exactly what I needed, thanks.
"David McRitchie" wrote:
=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?
|