View Single Post
  #2  
Old March 25th, 2010, 03:54 PM posted to microsoft.public.excel.newusers
John
external usenet poster
 
Posts: 563
Default 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