sheet name as cell : link?

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

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!!
 
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)
 
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
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!!
Click to expand...

.
Click to expand...
 
Back
Top