List tab names in cell range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large # of worksheets where the tab names will change. I would like
to list them on a separate worksheet that will reflect any changes made to
the worksheet tab. Is this possible or should I just re-type the list?
 
You can list them using

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

Which will return Sheet1. If the tab name changes, the formula will
change to reflect the change.
 
You have no idea how grateful for your solution! Thanks so much!

JE McGimpsey said:
You can list them using

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

Which will return Sheet1. If the tab name changes, the formula will
change to reflect the change.

JN said:
I have a large # of worksheets where the tab names will change. I would like
to list them on a separate worksheet that will reflect any changes made to
the worksheet tab. Is this possible or should I just re-type the list?
Click to expand...
Click to expand...
 
Back
Top