ExcelBanter - can i insert the name of the worksheet into a field?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - can i insert the name of the worksheet into a field? (https://www.excelbanter.com/excel-discussion-misc-queries/19010-can-i-insert-name-worksheet-into-field.html)

Kpan

can i insert the name of the worksheet into a field?

wanting to set up some excel templates - can i insert the name of the
worksheet into a field so that I don't have to rename every tab plus every
field each time I use the template

Jason Morin

One way:

=REPLACE(CELL("filename",A1),1,FIND("]",CELL
("filename",A1)),"")

Note: wb must saved for this to work.

HTH
Jason
Atlanta, GA

-----Original Message-----
wanting to set up some excel templates - can i insert
the name of the
worksheet into a field so that I don't have to rename
every tab plus every
field each time I use the template
.

All times are GMT +1. The time now is 05:58 AM.