worksheet reference
 

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,

worksheet reference
 

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,

worksheet reference
 

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,

worksheet reference
 

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,