C Curtis Nov 2, 2009 #1 I believe there is a way to name a cell in a worksheet to equal the worksheet name but I cannot recall Is there? Thanks
I believe there is a way to name a cell in a worksheet to equal the worksheet name but I cannot recall Is there? Thanks
J Jacob Skaria Nov 2, 2009 #2 Try =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) If this post helps click Yes
E Eduardo Nov 2, 2009 #3 Hi, for the worksheet name use Jacob suggestion if you want the workbook name use =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
Hi, for the worksheet name use Jacob suggestion if you want the workbook name use =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
J Jacob Skaria Nov 2, 2009 #4 Make sure you save the workbook..or else the formula will return #VALUE! error If this post helps click Yes --------------- Jacob Skaria Jacob Skaria said: Try =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) If this post helps click Yes --------------- Jacob Skaria Curtis said: I believe there is a way to name a cell in a worksheet to equal the worksheet name but I cannot recall Is there? Thanks Click to expand... Click to expand...
Make sure you save the workbook..or else the formula will return #VALUE! error If this post helps click Yes --------------- Jacob Skaria Jacob Skaria said: Try =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) If this post helps click Yes --------------- Jacob Skaria Curtis said: I believe there is a way to name a cell in a worksheet to equal the worksheet name but I cannot recall Is there? Thanks Click to expand... Click to expand...
R ryguy7272 Nov 2, 2009 #5 Take a look at this: http://www.ozgrid.com/VBA/return-sheet-name.htm Here are a few more to ponder http://www.exceltip.com/st/Cell_Function_Returns_Sheet_Name,_Workbook_Name_and_Path/180.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. Eduardo said: Hi, for the worksheet name use Jacob suggestion if you want the workbook name use =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) Curtis said: I believe there is a way to name a cell in a worksheet to equal the worksheet name but I cannot recall Is there? Thanks Click to expand... Click to expand...
Take a look at this: http://www.ozgrid.com/VBA/return-sheet-name.htm Here are a few more to ponder http://www.exceltip.com/st/Cell_Function_Returns_Sheet_Name,_Workbook_Name_and_Path/180.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. Eduardo said: Hi, for the worksheet name use Jacob suggestion if you want the workbook name use =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) Curtis said: I believe there is a way to name a cell in a worksheet to equal the worksheet name but I cannot recall Is there? Thanks Click to expand... Click to expand...
