=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kevin McCartney" wrote in message
...
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