ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking tab names to a cell in the sheet (https://www.excelbanter.com/excel-discussion-misc-queries/196355-linking-tab-names-cell-sheet.html)

Hankjam[_2_]

Linking tab names to a cell in the sheet
 
Is is the possible?

It would be neat.

Many thanks

Aj
<B6
Ecosse

RagDyeR

Linking tab names to a cell in the sheet
 
This will work *only* if the file has been *saved*:

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Hankjam" ........ wrote in message
...
Is is the possible?

It would be neat.

Many thanks

Aj
<B6
Ecosse





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

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