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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
shorten worksheet name 1
'Cannot insert object' message when I try to put a button on a worksheet 7
Importing data from Excel worksheet into Excel template 2
Sum Function 2
Insert Sheet Template Image broken (2010) 1
Editing cell names 1
add personal template to the insert worksheet dialog box 2

Top