| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel cell to reference tab name
Hi,
is it possible to have a cell auto populate with the name of the tab? I hope this doesn't require VB. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel cell to reference tab name
Yes, it i possible without VBA
See Bob Phillips' site for methods. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Thu, 7 Feb 2008 16:05:00 -0800, inspirz wrote: Hi, is it possible to have a cell auto populate with the name of the tab? I hope this doesn't require VB. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel cell to reference tab name
On Feb 7, 6:23*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Yes, it i possible without VBA See Bob Phillips' site for methods. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben *MS Excel MVP I can't explain it, but: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) TK On Thu, 7 Feb 2008 16:05:00 -0800, inspirz wrote: Hi, is it possible to have a cell auto populate with the name of the tab? *I hope this doesn't require VB. Thanks- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel cell to reference tab name
It requires vb
It's not too difficult of vb coding though. "inspirz" wrote: Hi, is it possible to have a cell auto populate with the name of the tab? I hope this doesn't require VB. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Hybrid Mode
