| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tab names in cells?
How can I see the shett tab name in a spreadsheet cell of that sheet?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab names in cells?
Please try this ...
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) *** Please do rate *** "MIKE" wrote: How can I see the shett tab name in a spreadsheet cell of that sheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab names in cells?
Note, if this formula appears not to work, then save the file first before
using it, then it works fine. Vaya con Dios, Chuck, CABGx3 "Naveen" wrote: Please try this ... =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) *** Please do rate *** "MIKE" wrote: How can I see the shett tab name in a spreadsheet cell of that sheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab names in cells?
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "MIKE" wrote in message ... How can I see the shett tab name in a spreadsheet cell of that sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I change the names of multiple cells at once? | Excel Discussion (Misc queries) | |||
| Referencing cells containing tab names? | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
