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!

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

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

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

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