| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell to reference sheet tab name
Is this an option? I want a cell on a worksheet to reference (copy) the sheet
tab name. Excel (Office 2003) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell to reference sheet tab name
The workbook needs to be saved
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) You can put this in any cell, the formula needs a cell reference that is what A1 does but it can be any cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Uggles" wrote in message ... Is this an option? I want a cell on a worksheet to reference (copy) the sheet tab name. Excel (Office 2003) |
| 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) | |||
| reference a cell on another sheet | Excel Discussion (Misc queries) | |||
| Is is possible for a cell to reference it's "sheet name"? | Excel Worksheet Functions | |||
| reference sheet tab name in a cell | Excel Discussion (Misc queries) | |||
| Cell to sheet reference | Excel Worksheet Functions | |||
Linear Mode
