+ Reply to Thread
Results 1 to 4 of 4

Including wildcard search in this program

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Singapore, Singapore
    MS-Off Ver
    Excel 2010
    Posts
    5

    Including wildcard search in this program

    Hello, i am currently working on a program to manage a large number of data, what i'm working on right now, is to come out with a code to do a wildcard search in this program and then any of the wildcard search result(the whole row) will be copy and paste into sheet2 of the same work book, so far, i am able to do a wildcard search in the same column. My question is, what should be added into this code to implement a wildcard search in the whole data rather just the column?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,407

    Re: Including wildcard search in this program

    Hi IcedMilkTea,

    Try this code :

    Please Login or Register  to view this content.
    GC Excel - My blog

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Registered User
    Join Date
    10-22-2013
    Location
    Singapore, Singapore
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Including wildcard search in this program

    Please Login or Register  to view this content.
    thanks GC EXCEL, the code works great, it's easy to understand but sorry to bother you again, may you explain what does xlValues and xlPart means in this line of code? thanks.

  4. #4
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,407

    Re: Including wildcard search in this program

    xlValues : look only at values (not formulas)
    xlPart : partial match only (similar to using wildcard)

    To get more info, place the cursor on the word Find and press F1 to get more detailed help on this function.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If, And, wildcard search
    By zachvu in forum Excel General
    Replies: 4
    Last Post: 07-14-2011, 06:41 PM
  2. Wildcard search using vlookup
    By hammer180 in forum Excel General
    Replies: 6
    Last Post: 07-08-2011, 04:35 PM
  3. Excel 2007 : search data using wildcard and sum it
    By eddy82 in forum Excel General
    Replies: 1
    Last Post: 06-03-2010, 06:23 AM
  4. Wildcard search for IF command
    By Zyphon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2008, 05:00 AM
  5. [SOLVED] Wildcard search functions within Vlookup
    By Benn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

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