Thread: search a string and copy rows thru vba

Originally Posted by DanExel

You will have to use the instr funktion.
if you need help, shout
Regards
Dan

Hi Dan, here i am again.

I was able to put successfully the Instr function to the part of looking per column. ("Omschrijving")

but the part when "ALL" is selected thats the problem.

i used this line in the part of looking at 1 column. ("D") and it works fine

If ColR.Rows(LSearchRow).Text = Tbx Or _
           InStr(ActiveCell.Value, UCase(Tbx)) > 0 Then

how do i integrate it in the following:

If Range("A" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("B" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("C" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("D" & CStr(LSearchRow)).Text = Tbx Or _
                    InStr(ActiveCell.Value, UCase(Tbx)) > 0 Or _
                    Range("E" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("F" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("G" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("H" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("I" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("J" & CStr(LSearchRow)).Text = Tbx Or _
                    Range("K" & CStr(LSearchRow)).Text = Tbx Then

Is it also possible with te Instr function to work with wild cards?
something like: Hdd%200gb% to search for more criteria

thnx for looking in to it "again"