Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I output the worksheet name in cell?
I want to make a cell that outputs the name of the worksheet.
|
#2
|
|||
|
|||
Hi Sloth,
Try this: =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1))) Note: this formula will work if your workbook has been saved at least once. Regards, KL "Sloth" wrote in message ... I want to make a cell that outputs the name of the worksheet. |
#3
|
|||
|
|||
One way:
http://www.mcgimpsey.com/excel/formu..._function.html In article , "Sloth" wrote: I want to make a cell that outputs the name of the worksheet. |
#4
|
|||
|
|||
Thanks guys, that's what I needed.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i rename worksheet to equal cell name | Excel Worksheet Functions | |||
I need to return the name of a worksheet in another worksheet cell? | Excel Worksheet Functions | |||
How can I link a cell in one worksheet to a cell in another works. | Excel Worksheet Functions | |||
copy a cell to another worksheet? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |