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

J

John

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
 
J

John

Ooops
The worksheet name not workbook, reading to fast.
Eduardo has the answer, now you have it all.
John
John said:
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 said:
Trying to find a command that returns a worksheet name inside a cell
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
References omit formatting and return cell address - not data 1
VBA copy cell to another worksheet 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Insert last saved date into header 9
Referrence a total in a cell on another worksheet 4
Excel Macro to hyperlink an archived worksheet to an index page 0

Top