Row delete macro

[wonderd]

The below code is used to search the cells in column A for a certain text "String1" if the string is found the entire row is deleted. How does the code have to be if I wanted to search more than one string? I have tried this using a comma to separate the strings ex: String1,String2 but this did not work. Any help greatly appreciated .

Please Login or Register  to view this content.

[mike7952]

One way

Please Login or Register  to view this content.

[wonderd]

Am getting Identifier to long error. I have about 100 or less stings I'm trying to work with.

[mike7952]

Maybe you can list the string down column A on another sheet and this will work

Please Login or Register  to view this content.

[wonderd]

So in A1 of the next sheet (sheet2) I would put the full string in this format "string1","string2" ?

What part of the code would have to be changed if I want to search column C instead of A?

[mike7952]

I would put the strings in cell by themself Cell A1 = String 1, A2= string2,A3 = string3 ect...
You can change the range below in the red

Please Login or Register  to view this content.

[wonderd]

that will not work for me. It would have to be stings in a continuous line like the original code you gave.

[mike7952]

Give this a try

Please Login or Register  to view this content.

[wonderd]

Okay thanks, what part of the code needs to changed to search column C instead of A of the sheet I'm running the macro on?

[mike7952]

At the top of code change a to c

Please Login or Register  to view this content.

[wonderd]

Yeap that seems to work! Thanks for the help really appreciate it!