Guys,
I need some help again. I just need the rows which has the string from the inputbox to be cut paste to sheet2. Here's the code I have so far.
Sub test2()
Dim btext As String
btext = InputBox("Insert in a text", "This accepts any input")
For i = Cells(Rows.Count, 3).End(xlUp).Row To 6 Step -1
With Cells(i, 3)
If Not IsEmpty(.Value) Then
If InStr(.Value, btext) = 0 Then _
Rows(i).EntireRow.Cut Destination:=Sheets("Sheet2")
'Range("D65536").End(xlUp).Offset(1, -3)
End If
End With
Next i
End Sub
Bookmarks