referencing Excel sheet name in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=REPLACE(CELL("Filename",A1),1,SEARCH("]",CELL("Filename",A1)),"")

which can be entered anywhere, including A1 itself.
 
Back
Top