thank you
-----Original Message-----
Hi
no code required :-) Try
For the sheet name:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1 ))-FIND
("]",CELL("file
name",A1),1))

File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL
("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)


--
Regards
Frank Kabel
Frankfurt, Germany

mike wrote:
I have a cell or cells that are goign to be named the
same as the sheet name is . Is it possible to link thm
together?? Or do i need to macro that? I wanted to
have a
cell in there that if the sheet name needed to be
changed.the cell to change too. that cell is refernced
in
a code.

thanks!!

.