sheet name as cell : link?
 

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!!

sheet name as cell : link?
 

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!!

sheet name as cell : link?
 

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!!

.