Can you cell reference for the title of the worksheet tab?
I want to pull the workshet name automatically from a cell within the
worksheet so that it is dynamic. |
Can you cell reference for the title of the worksheet tab?
"Rob" wrote:
I want to pull the workshet name automatically from a cell within the worksheet so that it is dynamic. Assuming the workbook was saved earlier (this is a requirement, book must be saved first) Click Insert Name Define Put under "Names in workbook:": WSN Put in the "Refers to:" box: =MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1") ))+1,32) Click OK The above defines WSN as a name we can use to refer to the sheetname in formulas in any sheet. It will auto-extract the sheetname implicitly. Technique came from a post by Harlan. For eg in any sheet, in any cell: =WSN will return the sheetname in the cell. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 05:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com