+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Kpan
    Guest

    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

  2. #2
    Jason Morin
    Guest

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

    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
    >.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1