Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Name of tab in sheet

    I have been asked if it is possible to show the name of the tab in a cell (NOT in the header or footer). I have found ways to put the name of the file in a cell and HELP shows how to put the file name and tab name in a cell - but this in fact only gives the ACTIVE tab. I cannot get a way to show the actual tab a cell sits on to show in a cell.

    anyone?
    Neil Eustice
    Woody Worshipper

  2. #2
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry - we have it...
    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
    Neil Eustice
    Woody Worshipper

Posting Permissions

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