Thread: how do I refer a cell to workbook name not worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote