ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell to reference sheet tab name (https://www.excelbanter.com/excel-discussion-misc-queries/149155-cell-reference-sheet-tab-name.html)

Uggles

Cell to reference sheet tab name
 
Is this an option? I want a cell on a worksheet to reference (copy) the sheet
tab name.
Excel (Office 2003)

Peo Sjoblom

Cell to reference sheet tab name
 
The workbook needs to be saved

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


You can put this in any cell, the formula needs a cell reference that is
what A1 does but it can be any cell


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Uggles" wrote in message
...
Is this an option? I want a cell on a worksheet to reference (copy) the
sheet
tab name.
Excel (Office 2003)





All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com