If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|