ExcelBanter - worksheet name in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - worksheet name in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/58190-worksheet-name-cell.html)

calin

worksheet name in a cell

how can I display the tab name of a woork sheet in a cell of the same
workshet?

--
calin
------------------------------------------------------------------------
calin's Profile: http://www.excelforum.com/member.php...o&userid=29265
View this thread: http://www.excelforum.com/showthread...hreadid=489826

Dave Peterson

worksheet name in a cell

The workbook has to be saved for this to work:

=MID(CELL("filename",a1),FIND("]",CELL("filename",a1))+1,255)

calin wrote:

how can I display the tab name of a woork sheet in a cell of the same
workshet?

--
calin
------------------------------------------------------------------------
calin's Profile: http://www.excelforum.com/member.php...o&userid=29265
View this thread: http://www.excelforum.com/showthread...hreadid=489826

--

Dave Peterson

calin

worksheet name in a cell

Thanks a lot!

--
calin
------------------------------------------------------------------------
calin's Profile: http://www.excelforum.com/member.php...o&userid=29265
View this thread: http://www.excelforum.com/showthread...hreadid=489826

All times are GMT +1. The time now is 08:06 PM.