close

Privacy guaranteed - Your email is not shared with anyone.

Excel Question

Discussion in 'Tech Talk' started by Cinic, Sep 15, 2004.

  1. Cinic

    Cinic Spongy Member

    Messages:
    1,959
    Likes Received:
    165
    Joined:
    Nov 17, 2001
    Location:
    Tempe, AZ
    In Excel, is it possible to insert the Tab name of a worksheet into that worksheet other than in the header or footer? If so, how do I do it? They have the AutoText button in the header and I tried using the info it puts in there, but to no avail.

    Help would be greatly appreciated.

    John
     
  2. Anon1

    Anon1

    Messages:
    1,222
    Likes Received:
    276
    Joined:
    Aug 17, 2000
    This function will return the entire path and worksheet name:

    =CELL("filename")

    This function will return just the worksheet name:

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

  3. Cinic

    Cinic Spongy Member

    Messages:
    1,959
    Likes Received:
    165
    Joined:
    Nov 17, 2001
    Location:
    Tempe, AZ
    That is a pretty sweet function.

    Thanks very much.

    ;c