Home |
Search |
Today's Posts |
#1
|
|||
|
|||
referencing Excel sheet name in cell
I am trying to reference the name of my worksheet in a cell. IE
=sheetname(this.sheet) output Sheet 1 Any ideas outside of VBA? is there a function that I can use? |
#2
|
|||
|
|||
=REPLACE(CELL("Filename",A1),1,SEARCH("]",CELL("Filename",A1)),"")
which can be entered anywhere, including A1 itself. Graham Tritton wrote: I am trying to reference the name of my worksheet in a cell. IE =sheetname(this.sheet) output Sheet 1 Any ideas outside of VBA? is there a function that I can use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert a barcode into an Excel sheet cell? | Excel Worksheet Functions | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How do I turn off relative cell referencing in excel? | New Users to Excel | |||
How do I change the Cell color automatically in an Excel sheet wh. | Excel Worksheet Functions | |||
In Excel, the sheet moves instead of the cell pointer. | Excel Worksheet Functions |