Displaying worksheet name in cell
Thanks, this worked great
"Dave Peterson" wrote:
Include a reference to each sheet:
=MID(CELL("filename",a1),FIND("]",CELL("filename",a1))+1,255)
Adrian wrote:
Is there any way to display a worksheet name in a cell (without using macros).
I have tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
but if I use this on multiple sheets in the same workbook, they all end up
displaying the same name!
--
Dave Peterson
|