J JiTS Ciao! Local time Today, 22:37 Joined Dec 12, 2003 Messages 77 Feb 22, 2006 #1 Hi! I would like to show the worksheet tab name in a cell of that specific worksheet? Is this possible with a formula in a cell?!?
Hi! I would like to show the worksheet tab name in a cell of that specific worksheet? Is this possible with a formula in a cell?!?
S shades Registered User. Local time Today, 15:37 Joined Mar 25, 2002 Messages 516 Feb 22, 2006 #2 Try this: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) You have to save the workbook first if it is a new workbook. ________ Buy Extreme Vaporizer Last edited: Feb 16, 2011
Try this: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) You have to save the workbook first if it is a new workbook. ________ Buy Extreme Vaporizer
S Sergeant Someone's gotta do it Local time Today, 16:37 Joined Jan 4, 2003 Messages 638 Feb 22, 2006 #3 shades said: Try this: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) You have to save the workbook first if it is a new workbook. Click to expand... Nice one. That is amazing!
shades said: Try this: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) You have to save the workbook first if it is a new workbook. Click to expand... Nice one. That is amazing!
