View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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,