Excel VBA - InStr in a Variable Range

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 RowCounter

I get a type mismatch error when I run the macro. I do not know how I have it written wrong.

1 Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like