Formula to Draw In Tab Name Into Sheet

[luke1438]

Is there any way to draw in the tab name into a cell in the sheet using a formula?

Thanks
Luke

 

[Dryver14]

I dont think there is a way to directly collect the tab name (vba exempt) but you could place the tab name or names in a cell or cells and reference that to save time writing it out again and again

 

[rallcorn]

I believe this will give you the worksheet name:

=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1))+1, SEARCH(".",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-1)

 

[njimack]

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

 

[luke1438]

Rallcorn,

Yes it does.

Thank you very much.
Luke

 

[rallcorn]

njimack's formula is better/shorter than mine.

 

[edokhotnik]

njimack's formula is better/shorter than mine.

For a different approach, I often use =REPLACE(CELL("filename",a1),1, FIND("]",CELL("filename",a1)),"") and it works well.