I am looking for a simple VBA function that will delete a line if there is a certain string inside a cell.
The string does NOT have to be exact.
Example: I want to delete all lines that have the word "string1" inside them, the strings are always in column C
cell C2 contains : "bla bla bla string1 bla bla"
cell C87 contains :" bla string1 bla bla bla bla".
cell C1234 : "string1 bla bla bla
etc
thank you very much !
Nicola
The string does NOT have to be exact.
Example: I want to delete all lines that have the word "string1" inside them, the strings are always in column C
cell C2 contains : "bla bla bla string1 bla bla"
cell C87 contains :" bla string1 bla bla bla bla".
cell C1234 : "string1 bla bla bla
etc
thank you very much !
Nicola