Formula Help
 

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

Thanks

Formula Help
 

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


"Curtis" wrote:

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

Thanks

Formula Help
 

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_Func..._Path/180.html

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jacob Skaria" wrote:

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


"Curtis" wrote:

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

Thanks

Formula Help
 

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

Thanks

"Jacob Skaria" wrote:

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


"Curtis" wrote:

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

Thanks