worksheet.name

  • Thread starter Thread starter Randy Ford
  • Start date Start date
Randy,

As long as the file has been saved at some time, use this formula in your
target cell
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename"
,A1),1))

The A1 is not relevant, it just anchors the formula to the worksheet the
formula is in.
 
Back
Top