Is there a formula that can display the Tab Name? If not can a Ma

[Guest]

Is there a formula that can display the Tab Name? If not can a Macro?

 

[Guest]

Try,


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

Mike

 

[Guest]

Thanks Mike

But this seems to tell you what Tab you are looking at. I need to know the
Tab the formula resides in.

Shawn

Try,


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

Mike

Is there a formula that can display the Tab Name? If not can a Macro?

 

[JE McGimpsey]

You need to reference a cell on the sheet in the CELL function. Take a
look here:

http://www.mcgimpsey.com/excel/formulae/cell_function.html