| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TAB NAME IN A WOORKBOOK REFER TO A CELL ON WORKSHEET | Excel Discussion (Misc queries) | |||
| How can I refer to a worksheet using text in a cell? | Excel Discussion (Misc queries) | |||
| refer to last cell in worksheet? | Excel Worksheet Functions | |||
| Refer to more than one worksheet in a workbook | Excel Worksheet Functions | |||
| how to I refer to current workbook without using its name? | Excel Worksheet Functions | |||
Linear Mode
