ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TAB name in cell (https://www.excelbanter.com/excel-discussion-misc-queries/61745-tab-name-cell.html)

ixlr84fun

TAB name in cell
 
I want to link the name if a workseet tab into the cell

is there an easy way to do this


JE McGimpsey

TAB name in cell
 
See

http://www.mcgimpsey.com/excel/formu..._function.html

In article . com,
"ixlr84fun" wrote:

I want to link the name if a workseet tab into the cell

is there an easy way to do this


ixlr84fun

TAB name in cell
 
that did it
you the man!

thanks


CLR

TAB name in cell
 
The workbook must first be saved, then

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

Vaya con Dios,
Chuck, CABGx3



"ixlr84fun" wrote:

I want to link the name if a workseet tab into the cell

is there an easy way to do this




All times are GMT +1. The time now is 10:34 PM.

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