ExcelBanter - How do I refer to the tab name in a cell formula in Excel?

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

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

- - How do I refer to the tab name in a cell formula in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/38505-how-do-i-refer-tab-name-cell-formula-excel.html)

Steven Reames

How do I refer to the tab name in a cell formula in Excel?

I'd like to refer to a tab name automatically in a cell formula, just like
you can autoinsert it as in the page header. Is this possible?

Chip Pearson

The following formula will return the tab name.

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

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Steven Reames" wrote in
message
...
I'd like to refer to a tab name automatically in a cell
formula, just like
you can autoinsert it as in the page header. Is this possible?

All times are GMT +1. The time now is 05:17 AM.