How To: Make cell reference the sheet name
Hi Kevin
try the following formulas - a little more than asked for
The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("file
name",A1),1))
File path and file name:
=CELL("filename",A1)
File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)
File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
HTH
Frank
Kevin McCartney wrote:
Hi,
I'd like a cell to contain the name of the sheet that it is, like
the &[TAB] in a footer, any ideas on what function can do this much
appriciated. I've looked at INFO function but no help, I know I could
do it in code but I don't want to add a module to the report.... get
to many questions about, oh your report contains viruses bla, bla.
TIA
KM
|