Hi both,

It's not working, I get a #VALUE! error.

Is it clear that I would like to have the 'tab' value ?

Rgds.


"Jacob Skaria" wrote:

Another one.. a bit shorter

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes
---------------
Jacob Skaria


"Gecko" wrote:

Hi,

Is there any formula that puts the value of the worksheet label in a cell ?

My header and footer are already full (and no way to clean 'm ...)

Thanks !