Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Putting the TAB (name of the worksheet) in a specified cell

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can you put the name of the woeksheet (tab) in a specified cell in excel

    [ This Message was edited by: JANICE_SMOKEY on 2002-04-24 06:32 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put this formula into whatever cell you want the Tab name.

    =MID(CELL("filename",G223),FIND("]",CELL("filename",G223))+1,LEN(CELL("filename",G223))-FIND("]",CELL("filename",G223)))
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  3. #3
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This will put the worksheet name into any cell reference (in this case A1)

    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,255)
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I cannot get either of these to work.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Make sure you're using these formulas in a workbook that has been saved.
    It's never too late to learn something new.

    Ricky

  6. #6
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can also use VBA code

    Range("$A$4")=ActiveSheet.Name

    Use this in an event procedure such as Activate or Befor Print, or some other macro

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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