Selecting a cells Containing specific Characters

Hello,

Perhaps someone could help me, I was unable to find a macro to what i thought to be a common thing.

I need an macro to select cells from a row, containing "WHI" and a small addition, delete the whole Row where the cell is located.


Thank you for taking time. I appreciate it!

Originally Posted by PCI

See next code

Please Login or Register  to view this content.

Hey, thanks for the reply, it works. But after running the macro it deletes only 1 row, after running again it deletes the 2 row and so on.

Originally Posted by PCI

OK

Here another one

Please Login or Register  to view this content.

It does the job.
MY table is 20 000 rows big. And it takes lot of time for for the macro to accomplish the task. It seems like it is searching for cells in the whole sheets. I was trying to lock it to range B:B but could make it work.

Originally Posted by PCI

For text to search only in column "B", used next code

Please Login or Register  to view this content.

Thank you !!!