vba code to delete rows with string of text found

Maybe something like this?

Option Compare Text
Sub DeleteRowsMatchingText()
    Dim rFoundText  As Range
    Dim rLookRange  As Range
    Dim vText()     As Variant
    Dim vItem       As Variant
    Dim lCalc       As Long
    
    With Application
        lCalc = .Calculation
        .ScreenUpdating = False
        .Calculation = xlCalculationManual
    End With
    
    vText = Array("County of Residence", "Age of Respondent", "Zip Code of Employment")
    Set rLookRange = Range("A:A,C:C") 'Change A:A and C:C to your search columns
    
    For Each vItem In vText
        Do
            Set rFoundText = rLookRange.Find(vItem, LookIn:=xlValues, lookat:=xlWhole)
            If Not rFoundText Is Nothing Then
                rFoundText.EntireRow.Delete
            End If
        Loop Until rFoundText Is Nothing
    Next
    
    Set rLookRange = Nothing
    Set rFoundText = Nothing
    
    With Application
        .ScreenUpdating = True
        .Calculation = lCalc
    End With
End Sub

How about this?

Option Compare Text
Option Explicit

Sub DeleteRowsMatchingText()
    Dim rFoundText  As Range
    Dim rLookRange  As Range
    Dim vText()     As Variant
    Dim vItem       As Variant
    Dim lCalc       As Long
    
    With Application
        lCalc = .Calculation
        .ScreenUpdating = False
        .Calculation = xlCalculationManual
    End With
    
    vText = Array("County of Residence", "Age of Respondent", "Zip Code of Employment")
    Set rLookRange = Range("A:A,C:C") 'Change A:A and C:C to your search columns
    
    For Each vItem In vText
        Do
            Set rFoundText = rLookRange.Find(vItem, LookIn:=xlValues, lookat:=xlWhole)
            If Not rFoundText Is Nothing Then
                rFoundText.EntireRow.Delete
            End If
        Loop Until rFoundText Is Nothing
    Next
    
    Set rLookRange = Nothing
    Set rFoundText = Nothing
    
    With Application
        .ScreenUpdating = True
        .Calculation = lCalc
    End With
End Sub

If you need to do this an a regular bases then a macor is a good way to go - It also depends on how many rows need to be checked.

It may alo possible to use formulas, manual sorting and manula deleting

The early part of thread

HTML Code: 

has various methods of using a macro to search for a whole cell content in a single column
These various methods can be modified to search a 2nd column.

Glad I could help If you haven't already, you should also check out the link mudraker posted. It's great to be able to use vba to solve an issue, but with a little bit of formula and native Excel function knowledge you can decide for yourself if vba is appropriate. Have a great day!