Worksheet Name in a Cell

[Kirk P.]

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?

 

[CarlosAntenna]

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

 

[N Harkawat]

=MID(CELL("filename",a1),SEARCH("]",CELL("filename",a1))+1,1024)

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
Regards
Frank Kabel
Frankfurt, Germany

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?

 

[Kirk P.]

The function on the web works perfectly. Thanks.