Including wildcard search in this program

[IcedMilkTea]

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.

[GC Excel]

Hi IcedMilkTea,

Try this code :

Please Login or Register  to view this content.

[IcedMilkTea]

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.

[GC Excel]

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.