Formula problem

[ed.ayers315]

I have the following formula in cells to pick up the tab name; my probelm it shows the name of other tabs when edited.

I there a way to get on the tab name of that worksheet?

IF(B2<>"",MID(CELL("filename"),FIND("]",CELL("filename"))+1,30)&": "&IF(A1<>"",ROW(2:2)-1,ROW(2:2)-2),"")


Thanks for any help!

 

[VoG]

Try

<code>=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))</code>

 

[ed.ayers315]

Worked great, thank you!!