Results 1 to 7 of 7

Thread: Find a worksheet throu a key word

  1. #1

    Find a worksheet throu a key word



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Sir

    How can i find an excel worksheet entering some text only that is contained by that worksheet

    warm regards

  2. #2
    Code:
    For Each ws in Worksheets
    
        If ws.Name Like "*Mytext*" Then
    
            ws.ACtivate
        End If
    Next ws

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    772
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Anmol786 View Post
    Sir

    How can i find an excel worksheet entering some text only that is contained by that worksheet

    warm regards
    Is the text you are looking for data in the sheets or part of the sheet names ?

  4. #4
    Quote Originally Posted by Anmol786 View Post
    Sir

    How can i find an excel worksheet entering some text only that is contained by that worksheet

    warm regards

    I want help in searching an excel file through entering a word

    suppose i write "arif" all files containing this word should be displayed

    Is that possible to find out a worksheet also

    plz reply

  5. #5
    I want help in searching an excel file through entering a word

    suppose i write "arif" all files containing this word should be displayed

    Is that possible to find out a worksheet also

    plz reply But i want an excel formula only as code written by you is quite inexlicable by me

  6. #6
    I want help in searching an excel file through entering a word

    suppose i write "arif" all files containing this word should be displayed

    Is that possible to find out a worksheet also

    plz reply

  7. #7
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    772
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Anmol786 View Post
    I want help in searching an excel file through entering a word

    suppose i write "arif" all files containing this word should be displayed

    Is that possible to find out a worksheet also

    plz reply
    Firstly, don't worry about using code. You don't have to understand everything about it to use it. How many car drivers understand everything about the way a car works?
    Assuming that your talking about finding a block of characters in your worksheet names, then the code that Bob has posted (#2) will do this for you after you have pressed a few keys and
    copy/pasted the code to the correct place.
    Can you please answer my question in post No 3, because if you are wanting to search worksheet cells for your characters, then that is a different issue altogether.
    It might be advisable to post a workbook with a few examples, so that we can understand what you mean by files, i.e. workbooks or worksheets).

Posting Permissions

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