| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a cell reference to return name of the tab?
For example... the tab name is Apples. I want cell A1 to say Apples
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a cell reference to return name of the tab?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
-- Gary's Student "pameluh" wrote: For example... the tab name is Apples. I want cell A1 to say Apples |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a cell reference to return name of the tab?
Just to add.....
The file must already exist. It must have been saved and given a name. Biff "Gary''s Student" wrote in message ... =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) -- Gary's Student "pameluh" wrote: For example... the tab name is Apples. I want cell A1 to say Apples |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a cell reference to return name of the tab?
The file must already exist. It must have been saved and given a name.
Another way to say this is: The file must have been previously saved for this to work. -- Regards, Tom Ogilvy "Biff" wrote in message ... Just to add..... The file must already exist. It must have been saved and given a name. Biff "Gary''s Student" wrote in message ... =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) -- Gary's Student "pameluh" wrote: For example... the tab name is Apples. I want cell A1 to say Apples |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a cell reference to return name of the tab?
Brilliant! Thanks guys! You just made me a hero! Much appreciated!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell reference instead of value | Excel Discussion (Misc queries) | |||
| Lookup a value and return its cell reference instead of the value | Excel Discussion (Misc queries) | |||
| GETPIVOTDATA - return cell reference, not value | Excel Worksheet Functions | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Linear Mode
