If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula to get sheet name
hi,
can a formula retreive a worksheet name or does it need to be macro based? thanks, N.S. |
#2
|
|||
|
|||
Hi Nigel,
This formula that takes care of the possible situation whereby you have only one sheet in the workbook and its name is the same as the workbook's. Note: CELL("filename") will only work if the file has been saved at least once and if the file is opened in a different language system, the argument "filename" will need to be changed manually to the corresponding word (e.g. in Spanish "nombrearchivo"): =LOOKUP(REPT("z",255),SUBSTITUTE(MID(CELL("filenam e"),1+FIND({"*","]"},SUBSTITUTE(CELL("filename"),"\","*",LEN(CELL("f ilename"))-LEN(SUBSTITUTE(CELL("filename"),"\","")))),255),". xls","")) Regards, KL "Nigel" wrote in message ... hi, can a formula retreive a worksheet name or does it need to be macro based? thanks, N.S. |
#3
|
|||
|
|||
Copy the following code (Verbatim) into any cell (make sure the book is saved
first): =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) -- Regards, Dave !-- "Nigel" wrote: hi, can a formula retreive a worksheet name or does it need to be macro based? thanks, N.S. |
#4
|
|||
|
|||
Nigel,
Try the following formula. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) The file must have been saved to disk in order for this to work. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nigel" wrote in message ... hi, can a formula retreive a worksheet name or does it need to be macro based? thanks, N.S. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change sheet name in formula | kojimm | Worksheet Functions | 2 | July 6th, 2005 09:44 AM |
Balance sheet Formula | TC | General Discussion | 0 | February 23rd, 2005 08:13 PM |
Formula Help | Vicki | Worksheet Functions | 3 | September 3rd, 2004 09:18 PM |
Sheet name in formula | Kimberly | Worksheet Functions | 2 | March 18th, 2004 06:17 PM |
Sheet Names | Joseph M. Yonek | Worksheet Functions | 6 | January 3rd, 2004 02:15 AM |