Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Worksheet Name in a Cell
I know I can get the file name and path in a cell with =Cell("filename"), is
there some similar functionality for getting the sheet name in a cell? |
#2
|
|||
|
|||
One of the Gurus in this NG has a web page with examples of how you can
parse bits out of the Cell() function, but I don't remember the URL. I'm sure someone will come up with it. Carlos "Kirk P." wrote in message ... I know I can get the file name and path in a cell with =Cell("filename"), is there some similar functionality for getting the sheet name in a cell? |
#3
|
|||
|
|||
=MID(CELL("filename",a1),SEARCH("]",CELL("filename",a1))+1,1024)
"Kirk P." wrote in message ... I know I can get the file name and path in a cell with =Cell("filename"), is there some similar functionality for getting the sheet name in a cell? |
#4
|
|||
|
|||
Hi
see: http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Regards Frank Kabel Frankfurt, Germany "Kirk P." schrieb im Newsbeitrag ... I know I can get the file name and path in a cell with =Cell("filename"), is there some similar functionality for getting the sheet name in a cell? |
#5
|
|||
|
|||
The function on the web works perfectly. Thanks.
"Frank Kabel" wrote: Hi see: http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Regards Frank Kabel Frankfurt, Germany "Kirk P." schrieb im Newsbeitrag ... I know I can get the file name and path in a cell with =Cell("filename"), is there some similar functionality for getting the sheet name in a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) | |||
name of another worksheet in cell for reference | Excel Worksheet Functions | |||
Need formule which would find cell (exmp b3) value on another worksheet! please help! | Excel Worksheet Functions | |||
Need find cell b3 value on another worksheet! | Excel Worksheet Functions |