ExcelBanter - Ms Excel

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

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

- - Ms Excel (https://www.excelbanter.com/excel-discussion-misc-queries/231692-ms-excel.html)

MRO

Ms Excel

Hi
Is there a way I can reference a cell to look at the tab name only?
&[TAB] in footer but I want it visible in a cell

Eduardo

Ms Excel

Hi,
In the cell where you want the tab name enter

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

if this helps please click yes, thanks

"MRO" wrote:

Hi
Is there a way I can reference a cell to look at the tab name only?
&[TAB] in footer but I want it visible in a cell

All times are GMT +1. The time now is 08:23 AM.