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? |
=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? |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com