Is there a function key or formula that will put the name of the worksheet
into a cell on the same worksheet automatically?

No function key, but, there is a formula. It looks like the following, simply
copy and paste it into any cell as is, okay! Here it is:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

Hope this helps!



"RC" wrote:

Is there a function key or formula that will put the name of the worksheet
into a cell on the same worksheet automatically?

Check out


http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
"RC" wrote:

Is there a function key or formula that will put the name of the worksheet
into a cell on the same worksheet automatically?