I've tried to find ways to delete an entire row if a cell contains a specific value and I've found some that use AutoFilter and some that use loops but none of which would allow me to specify more than one criterion.

I have a list of members for our business and some of these members are actually staff and employees. I can identify the staff/employees by their member numbers and I would like to delete entire rows containing any information about them so I can focus only on the customer base.

I have a list of 22 staff/employee member numbers and would like to get rid of any row in which the member ID column contains any of those 22 numbers.

How would I macro this?