Changing code to work on entire sheet instead of specific columns

Hello. How can I get this code to work on the whole sheet, instead of just column 1? I want to search for the values below in the entiresheet and delete them (just the values, not the row). Thanks.

Please Login or Register  to view this content.

You might want to change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

If you don't want the row deleted as you mentioned in your post.

Thanks MR Shg and jolivanes. That worked!!