Thanks, this worked great

"Paul Sheppard" wrote:


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!

Hi Adrian

Try this

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1)))


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=479848