Delete rows based on list of different words/arguments

[BexcelB]

Hi,

I have a list of 25.000 products and some rows has to be deleted since they are not interestning.

Is is possible to create VBA code that goes trough the complete sheet and delete rows based on a list of different words/different arguments.
Product name often consist two words but the VBA code just have look on only one word.

Hope it makes sense.

Best regards
BexcelB

 

[shinigamilight]

Can add another line V = Array("Louis", "Becky") etc. below to exisiting one?

You mean you want to add more keywords that should be deleted?
just do this

V = Array("Louis", "Becky", "Charles","Timothy", "Hailey")

 

[BexcelB]

You mean you want to add more keywords that should be deleted?
just do this

V = Array("Louis", "Becky", "Charles","Timothy", "Hailey")

That I know and that works perfect, but when I've used all possible fields in that string and want to continue on next line something goes wrong.

 

[shinigamilight]

I've used all possible fields in that string

I don't understand what you mean by this, unfortunately. Possible field in which string?

 

[BexcelB]

I don't understand what you mean by this, unfortunately. Possible field in which string?

Still newbie in this so maybe I'm not using the right "words". Each line contains is it 1023 characters? My challenge is that I've used all characters/put in the maximum of keywords in the "V = Array" line. How can add extra lines? Hope it makes sense.

 

[shinigamilight]

Put a space and then add an underscore and press enter. that's how you take the same line to the next line.