View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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