Deleting rows in Excel based on criteria

[SteveM]

Is it possible to automate the deletion of row based on a
criteria, preferably through a macro? i.e. - run the
macro and delete any row who has "NO" in last column.

 

[Ron de Bruin]

and delete any row who has "NO" in last column.

last column IV ??

 

[Guest]

I'm not sure what you mean...

I need to delete an entire row from the worksheet if it
meets a criteria that I set, i.e. any row that has the
value "Joe" in column E would be deleted from the sheet....

Thanks

-----Original Message-----

last column IV ??

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"SteveM" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

value "Joe" in column E
Now I know the column

Example for Sheet1

Sub Test()
Dim r As Long
Application.ScreenUpdating = False
With Worksheets("Sheet1")
For r = .UsedRange.Rows.Count To 1 Step -1
If .Cells(r, "E").Value = "Joe" Then .Rows(r).Delete
Next
End With
Application.ScreenUpdating = True
End Sub