| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Tab Name
I haven't been able to find a function that returns the name of a worksheet
tab. In custom headers, the tab is referenced by &[TAB] but this doesn't work as a cell formula. Is there any way to do it? Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Tab Name
Try this
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) Note that the workbook needs to be saved and don't replace filename with the name of the file, it is part of this function -- Regards, Peo Sjoblom "oldblindpew" wrote in message ... I haven't been able to find a function that returns the name of a worksheet tab. In custom headers, the tab is referenced by &[TAB] but this doesn't work as a cell formula. Is there any way to do it? Thanks, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Tab Name
Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) The file must have been saved at least once for that to work. -- Biff Microsoft Excel MVP "oldblindpew" wrote in message ... I haven't been able to find a function that returns the name of a worksheet tab. In custom headers, the tab is referenced by &[TAB] but this doesn't work as a cell formula. Is there any way to do it? Thanks, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Tab Name
i think You you can use this UDF
Function SheetName() SheetName = Application.Caller.Parent.Name End Function |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return date if in range, else return blank | Excel Worksheet Functions | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| I need to return "" instead of 0 | Excel Worksheet Functions | |||
Linear Mode
