excel vba - Deleting rows with specific words with VBA -

Currently, my excel data contains specific words and # n / a, like the word "build one" "proxy" Are there. I have prepared a code in which it only removes one condition, but I want it for many words. Below is my code welcome any help.

  subdel () dim rng1 range set as rng1 = class ([b2], cell (rows.account, "b"). End (xlUp)) ActiveSheet.AutoFilterMode = With False RNG 1. Autofilter Field: = 1, Criteria: = ("#N / A"). End with extlay ending  

As a creator for your word list Use a variable array.

  Range in the form of slow rng1, variant as vDELs vDELs = Array ("# ​​set RNG = 1" (range [[b2], cell (rows count, " B "). End (xliepe)) ActiveSheet.AutoFilterMode = rng1 with incorrect. Autofilter field: = 1, Criterion 1: = (vDELs), operator: = xlFilter with Values. Offset (1, 0) If CBU ( Application: Shuttle (103,). Good catch on bracket of array in Autofilter &   
  Criterion 1 with _ enduro. End end. = (VDELs) . This is important. There is also a good idea to check that before operation you have to delete rows or not.