Delete row if Column H contains any of the following values - VBA

[CC268]

I simply want to delete a row if Column H contains any of the following values:
-%
-Resistor
-Capacitor
-MCKT
-Connector
-anything else I may want to add to this list...


Thanks!

 

[Joe4]

Did you try the update I made to Rick's code for you?

 

[Zshanar69]

Actually

Which rows does it skip? ReadRow is the row being checked, so needs to start at 4. n is used to calculate how many rows to check. So if it's too high, some of the rows at the end won't get checked.

Actually I did it last night on my own now I am not in front of screen I'll check & reply you back in few hours!

 

[Zshanar69]

Thx it did

Zshanar69 - in my code that you quoted, you just need to change the 1 in the ReadRow... and For... lines to the row number of the first cell. So for H4:

ReadRow = 1
For n = 1 to LastRowNum

becomes:

ReadRow = 4
For n = 4 to LastRowNum

Thx it worked!
Actually I just changed n = 4 to LastRowNum
But didn't change ReadRow = 4
Now this works just fine!