| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sheet name in Cell
How do I get the sheet name in a cell. TIA
Greg |
|
#2
|
|||
|
|||
|
Take a look he
http://www.mcgimpsey.com/excel/formu..._function.html In article , "GregR" wrote: How do I get the sheet name in a cell. TIA |
|
#3
|
|||
|
|||
|
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34)
you can put this formula in any cell, even A1 Regards, Peo Sjoblom "GregR" wrote: How do I get the sheet name in a cell. TIA Greg |
|
#4
|
|||
|
|||
|
JE and Peo, thank you very much.
Greg "Peo Sjoblom" wrote in message ... =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) you can put this formula in any cell, even A1 Regards, Peo Sjoblom "GregR" wrote: How do I get the sheet name in a cell. TIA Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Cell reference - for the sheet name, can I use a variable? | Excel Discussion (Misc queries) | |||
| Displaying sheet and cell value in another cell | Excel Discussion (Misc queries) | |||
| Cell Colors and Sheet Protection | Excel Discussion (Misc queries) | |||
| How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
Linear Mode
