I have a macro setup to create a helper column and paste a vlookup formula to return wether or not an account number matches on another sheet or not. Now i need the macro to delete the rows that have the matching account numbers but keep the rows that have a n/a where it doesn't match. ANy help? 

    Range("AB6").Select
    ActiveCell.FormulaR1C1 = _
        "=VLOOKUP(RC[-27],Delinquency_Report.xls!R7C3:R2133C3,1,FALSE)"
    Selection.AutoFill Destination:=Range("AB6:AB557"), Type:=xlFillDefault
    Range("AB6:AB557").Select
End Sub