Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I cause a cell to return the sheet name i.e. sheet 1?
I just want the cell to give the title of the sheet. For example: Sheet 1
would be displayed in A2 if A2 had this function. |
#2
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/ In article , "Matt" wrote: I just want the cell to give the title of the sheet. For example: Sheet 1 would be displayed in A2 if A2 had this function. http://www.mcgimpsey.com/excel/formu..._function.html |
#3
|
|||
|
|||
One way
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,34) you need to have saved the workbook -- Regards, Peo Sjoblom "Matt" wrote in message ... I just want the cell to give the title of the sheet. For example: Sheet 1 would be displayed in A2 if A2 had this function. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
Need formula for sheet & cell reference | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |