inserting worksheet name in a cell using function

  • Thread starter Thread starter GUS
  • Start date Start date
G

GUS

I have found a formula on the web help site to
automatically insert a worksheet name into a cell of the
worksheet. I have several worksheets and wish to
identify each worksheet automatically in a cell of each
worksheet. When I use the formula it initially brings in
the correct worksheet name. However when I select
another worksheet the prior name appears in the selected
cell.

Perhaps I need to change something in my formula or this
is a problem that I can't correct. What is your
suggestion?

The following formula is what I am using in each
worksheet.
=MID(CELL("filename"),SEARCH("[",CELL("filename"))
+18,SEARCH("]",CELL("filename"))-2 )

Perhaps there is a simpler way to insert the worksheet
name into a cell. Something like; =cell("worksheet"),
or =cell("filename,-path"). I haven't been able to find
the solution.

Please advise.
 
Back
Top