I am trying to use a for loop to loop through the cells in a column and pick out parts with a specific description. To do this, I am using InStr, which I am unfamiliar with.
Here is the code I have now:
For RowCounter = LastRow To 1 Step -1 If InStr(Range("F" & RowCounter), "welder") <> 0 Then Rows(RowCounter).EntireRow.Cut _ Destination:=Sheets("FA3").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) End If
Next RowCounterI get a type mismatch error when I run the macro. I do not know how I have it written wrong.
1 Reset to default