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
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
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
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks