ExcelBanter - is it possible to reference a tab name within a cell by formula?

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

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

- - is it possible to reference a tab name within a cell by formula? (https://www.excelbanter.com/excel-discussion-misc-queries/189380-possible-reference-tab-name-within-cell-formula.html)

Emma_D

is it possible to reference a tab name within a cell by formula?

I know I can show the tab name in the footer on a document when I print it,
but is there anyway of showing what the tab name is within the worksheet
itself on the screen?

dhstein

is it possible to reference a tab name within a cell by formula?

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

"Emma_D" wrote:

I know I can show the tab name in the footer on a document when I print it,
but is there anyway of showing what the tab name is within the worksheet
itself on the screen?

All times are GMT +1. The time now is 07:28 PM.