Custom macro for removing cells containing specific location keywords

you could create 2 array's and compare each cell to what is in the arrays....actually you could create 1 big array and do the same thing....