How to delete row if value x is found in all three columns

[CruelMind]

Hello
I am looking for a makro that is deleting an entire row if the value x is in all three rows (A,C,E). I have a makro to delete row if the value x is found in one column, but it only should be deleted if found in all.

Example.

Row A C E
6 text text x
7 text text text
8 x text x
9 x x x <-- Makro should only delete this row
10 text x text

Help is much appreciated. This is the Makro is use to delete if value = x if it only matters for row A

Sub Delete_value()

Application.ScreenUpdating = False
Sheets("test").Select
Range("A8:A12").Select
Do Until IsEmpty(ActiveCell.Value)
If ActiveCell.Value = ("x") Then
Selection.EntireRow.Delete
Else
ActiveCell.Offset(1, 0).Select
End If
Loop
Application.ScreenUpdating = True

End Sub

[Solus Rankin]

Maybe

Sub Delete_value()

Dim cel As Range

Application.ScreenUpdating = False
Sheets("test").Select
For Each cel In Range("A8:A12")
    If cel.value = "x" And Cells(cel.Row, 3).value = "x" And Cells(cel.Row, 5) = "x" Then
        cel.EntireRow.Delete
    End If
next
Application.ScreenUpdating = True

End Sub

[martindwilson]

you could use something like

Sub test()

    With Range("A2:E200")
    .AutoFilter
    .AutoFilter Field:=1, Criteria1:="x"
    .AutoFilter Field:=3, Criteria1:="x"
    .AutoFilter Field:=5, Criteria1:="x"
    .SpecialCells(xlCellTypeVisible).Select
    .EntireRow.Delete
    End With
    Range("a1").Select
End Sub