+ Reply to Thread
Results 1 to 3 of 3

Search for multiple things at once

  1. #1
    MDW
    Guest

    Search for multiple things at once

    I'm trying to do a search to determine if any cells contain references to
    other worksheets in the same workbook. For instance, if I've got a worksheet
    named "Daily" and another worksheet named "YTD", I may have a function like
    this:

    =MAX(Daily!A2:A999)

    I want to identify that cell as referring to another worksheet.

    I have a search feature that currently looks for linked worksheets according
    to one of three strings (strSearch is a String variable containing the name
    of the worksheet I'm searching for):

    strSearch & "'"
    strSearch & "!"
    strSearch & ","

    I can't use wildcards (strSearch & "*") because I have other cells that link
    to entirely different WORKBOOKS, that may have the word "Daily" as part of
    the path (does that make sense)?

    Right now I'm executing three different searches, as shown above.

    Set objFind = objWorksheet.Find(strSearch & "'", LookIn:=xlFormulas).
    etc.

    Is there a way I can combine these three parameters into one search?
    Something like strSearch & "'" OR strSearch & "!" OR strSearch & ","


    I hope this makes sense. TIA.


    --
    Hmm...they have the Internet on COMPUTERS now!

  2. #2
    Registered User
    Join Date
    07-28-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Search for multiple things at once

    Sorry I am newbie..
    My I ask for the answer to this thread?
    I need it badly.
    Thanks for any response

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Search for multiple things at once

    Hi raymond72 & Welcome to the Forum,

    As you can clearly see, this thread is seven years old and it doesn't appear to have been answered.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1