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