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?

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?

=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?

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?

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?