| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy tab name to a cell or opposite
What is the the index of the name of the tab? Who can I get the tab name
autmatic to a cell or the other way around? It will be nice to type a name once - no mistakes and time saving when you use a lot of pages (sheets) and refere to form the first sheet in abook. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy tab name to a cell or opposite
Try the below formula to retrive the tab name to a cell...To name the tab as
per cell you would require a VBA solution =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) -- Jacob "RG" wrote: What is the the index of the name of the tab? Who can I get the tab name autmatic to a cell or the other way around? It will be nice to type a name once - no mistakes and time saving when you use a lot of pages (sheets) and refere to form the first sheet in abook. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Value in Cell Diagonally opposite | New Users to Excel | |||
| copy cell from above with opposite sign | Excel Worksheet Functions | |||
| enter 2 values in opposite corners of a cell | Excel Discussion (Misc queries) | |||
| Opposite of SUM function is ?? | Excel Discussion (Misc queries) | |||
| return opposite | Excel Worksheet Functions | |||
Hybrid Mode
