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

K

Kpan

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
 
J

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
 
Top