worksheet name

T

timo

Hello All,

is there a formula I can use to place the worksheet name
in a cell? I'm looking for something similar to adding
[tab] in the header.

Thanks in advance
 
J

Jason Morin

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

Note: wb must be saved for it to work.

HTH
Jason
Atlanta, GA
 
Top