how do I refer a cell to workbook name not worksheet
 

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

how do I refer a cell to workbook name not worksheet
 

=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

On Tue, 2 Oct 2007 11:44:01 -0700, esparzaone
wrote:

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

how do I refer a cell to workbook name not worksheet
 

Amazing - Thank you!

"Gord Dibben" wrote:

=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

On Tue, 2 Oct 2007 11:44:01 -0700, esparzaone
wrote:

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