Delete entire row depending on the contents of a cell

I'm trying to write a procedure which will search the contents of Column B of my worksheet for the word "Total". Whenever the word "Total" is found in a cell within Column B, the entire row should be deleted.
How would I do this? Thank you in advance for any help.

Try this

Please Login or Register  to view this content.

Shijesh Kumar, perhaps you should add a loop to your code to handle multiple instances ?

Hi DonkeyOte,

Its just a sample code...explaining how u can achive the result...
However below is with loop

Please Login or Register  to view this content.

LemonTwist, please see below:

Please Login or Register  to view this content.