Formula Help

[Curtis]

Is there a formula that would allow the name of a workbook or worksheet to
show in a cell inside a worksheet?

Thanks

 

[Jacob Skaria]

What about your previous post..??? Try the below formulas in a saved workbook

'Workbook and worksheet name
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1)),99)

'workbooknam
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

'worksheet name
=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes

 

[ryguy7272]

Same question? Same answer.

Take a look at this:
http://www.ozgrid.com/VBA/return-sheet-name.htm
MAKE SURE YOU SAVE THE WORKBOOK TO SEE THE DESIRED RESULT.

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''.

What about your previous post..??? Try the below formulas in a saved workbook

'Workbook and worksheet name
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1)),99)

'workbookname
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

'worksheet name
=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes
---------------
Jacob Skaria

Is there a formula that would allow the name of a workbook or worksheet to
show in a cell inside a worksheet?

Thanks

 

[Curtis]

Sry... Yes I posted it twice as my computer looked like it timed out... I
should have checked

Thanks

What about your previous post..??? Try the below formulas in a saved workbook

'Workbook and worksheet name
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1)),99)

'workbookname
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

'worksheet name
=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes
---------------
Jacob Skaria

Is there a formula that would allow the name of a workbook or worksheet to
show in a cell inside a worksheet?

Thanks