Need function to insert worksheet name into a cell of that worksheet.

[August Meduna]

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.

Thanks

 

[Dave Peterson]

Try the response to this FAQ at Debra Dalgleish's site:
http://www.contextures.com/xlfaqFun.html#SheetName

Notice that the response includes a cell from the worksheet.

It's probably a good thing to add to your formula, too!

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.

Thanks

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

For an easier formula you would need vBA (a user defined function)