List tab names in cell range

J

JN

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?
 
J

JE McGimpsey

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.
 
J

JN

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...
 
Top