is there a comand to return the mane of a worksheet inside a cell
 

Trying to find a command that returns a worksheet name inside a cell

is there a comand to return the mane of a worksheet inside a cell
 

Hi Fabian
Try this,
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
This one will give you the full path: =CELL("filename")
HTH
John
"Fabian" wrote in message
...
Trying to find a command that returns a worksheet name inside a cell

is there a comand to return the mane of a worksheet inside a cell
 

Hi,

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


"Fabian" wrote:

Trying to find a command that returns a worksheet name inside a cell

is there a comand to return the mane of a worksheet inside a cell
 

Ooops
The worksheet name not workbook, reading to fast.
Eduardo has the answer, now you have it all.
John
"John" wrote in message
...
Hi Fabian
Try this,
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
This one will give you the full path: =CELL("filename")
HTH
John
"Fabian" wrote in message
...
Trying to find a command that returns a worksheet name inside a cell