Use of Worksheet Tab Name

[Grampa425]

Want to put a new name on a worksheet tab (which I know how to do) and
then reference that TAB on the work sheet. For example, if I name a
worksheet XYZ, need a process where I can say Cell A1 (or whatever) =
TAB NAME (XYZ or anything). How do I do that?

 

[J.E. McGimpsey]

one way:

=MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255)

 

[Dave Peterson]

And I bet that JE meant to add that the workbook has to be saved at least one
time for this to work.

(Welcome back, JE.)

one way:

=MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255)

Want to put a new name on a worksheet tab (which I know how to do) and
then reference that TAB on the work sheet. For example, if I name a
worksheet XYZ, need a process where I can say Cell A1 (or whatever) =
TAB NAME (XYZ or anything). How do I do that?