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
|