how do I refer a cell to workbook name not worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a cell to refer to the name of the workbook not the tab or the
worksheet name. I know it must be similar but can't figure it out. Please
help.

Zenia
 
Amazing - Thank you!

Gord Dibben said:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename"),1)-1)

For more like the above see Bob Phillips' site.

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


Gord Dibben MS Excel MVP

I need a cell to refer to the name of the workbook not the tab or the
worksheet name. I know it must be similar but can't figure it out. Please
help.

Zenia
Click to expand...
Click to expand...
 
Back
Top