Displaying Tab Name in A Cell (Excel 2000)

Topic

New Reply

Is there an easy way to automatically display the tab name in a particular cell without a macro ?

Reply | Quote

Replies

Put this in a cell:
=MID(CELL(“filename”,$A$1),FIND(“]”,CELL(“filename”,$A$1))+1,LEN(CELL(“filename”,$A$1)))

Steve

Reply | Quote

Steve,

Thanks. It’s working !

TQ

Reply | Quote

Steve,

Thanks. It’s working !

TQ

Reply | Quote

I use the morefunc add-in that provides many usable features. One is “Filename” so you can use =FILENAME() to achieve this.
http://longre.free.fr/english/index.html%5B/url%5D

Reply | Quote

I use the morefunc add-in that provides many usable features. One is “Filename” so you can use =FILENAME() to achieve this.
http://longre.free.fr/english/index.html%5B/url%5D

Reply | Quote

Put this in a cell:
=MID(CELL(“filename”,$A$1),FIND(“]”,CELL(“filename”,$A$1))+1,LEN(CELL(“filename”,$A$1)))

Steve

Reply | Quote