Use of Worksheet Tab Name

  • Thread starter Thread starter Grampa425
  • Start date Start date
G

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?
 
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.)

J.E. McGimpsey said:
one way:

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

Grampa425 said:
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?
Click to expand...
Click to expand...
 
Back
Top