VBA code to retain the rows with specific text.

[mchilapur]

Hello all,
I have around 6000 plus of data in A:A column.Format is something like below

"I am in search of logic"
"I didnt find"
"I wont find"
"You find it" etc

I want a VBA code to retain the rows with "Search" word and delete rest all.

Means, Row with "I am in search of logic" must remain.

Also provide the code with multiple criterias if possible.

Please help.

[:) Sixthsense :)]

Please Login or Register  to view this content.

[davesexcel]

The attached example uses about 8400 rows , click the DelRows button to delete rows.

Please Login or Register  to view this content.

[mchilapur]

Works perfect..!!! Thank you very much...