I think you mean that you want to delete the whole row which contains AV8032 exactly. Also, It will need to be done on different sheets where AV8032 can be located in many different rows and columns. If this is true then this code should work for you. TRY ON A COPY OF YOUR WORKBOOK.
Let me know if it works. Also in the future you may want to look at posting your questions on a different forum. The napoleon complex of the moderators around here is quite appaling. They are way more concerned about you following all 150 of their rules to the "T" rather than helping those in need. Either way let me know if it helps. Oh btw moderator can i please get another infraction for helping someone?