Hello,

I recently discovered the CEll function and the INFO function, which can
allow you to return information about formats, references and operating
environment. In the CELL function you can reference the "filename," however I
do not know a way to specifically reference the individual worksheet, only.

How can I reference the worksheet using either this or a similar function?

Thanks,

This should work:

=MID(CELL("Filename",$A$1),FIND("]",CELL("filename",$A$1))+1,256)

HTH,
Elkar


"tjh" wrote:

Hello,

I recently discovered the CEll function and the INFO function, which can
allow you to return information about formats, references and operating
environment. In the CELL function you can reference the "filename," however I
do not know a way to specifically reference the individual worksheet, only.

How can I reference the worksheet using either this or a similar function?

Thanks,

See http://xldynamic.com/source/xld.xlFAQ0002.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"tjh" wrote in message
...
Hello,

I recently discovered the CEll function and the INFO function, which can
allow you to return information about formats, references and operating
environment. In the CELL function you can reference the "filename,"
however I
do not know a way to specifically reference the individual worksheet,
only.

How can I reference the worksheet using either this or a similar function?

Thanks,

Thank You, that helps.

One more question... Is it possible to name a worksheet based on a cell
value or formula? (without using vba)






"Bob Phillips" wrote:

See http://xldynamic.com/source/xld.xlFAQ0002.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"tjh" wrote in message
...
Hello,

I recently discovered the CEll function and the INFO function, which can
allow you to return information about formats, references and operating
environment. In the CELL function you can reference the "filename,"
however I
do not know a way to specifically reference the individual worksheet,
only.

How can I reference the worksheet using either this or a similar function?

Thanks,