Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    How would I insert a tab name/label into its respective worksheet at say A1?
    Thanks in advance.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    Type and save the file

    =MID(CELL("filename"),(FIND("]",CELL("filename"))+1),50)
    Jerry

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='Jezza' post='782351' date='29-Jun-2009 15:26']Type and save the file

    =MID(CELL("filename"),(FIND("]",CELL("filename"))+1),50)[/quote]

    Thanks Jezza. I just realized that Morefunc has a function, "Sheetname()", that will do the same thing...

Posting Permissions

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