Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to delete on a condition
Hi,
I am trying to delete entire rows based on a condition. My condition is simple, I put the word "delete" in column b of the worksheet. If it has "delete" then wa lah! Its supposed to be gone. Except I can't figure out how to get it done. I've tried a different criteria with putting in a number instead but I am useless here. Please help? Todd Sub deleteif() On Error Resume Next For i = Cells(Rows.Count, "a").End(xlUp).Row To 1 Step -1 If UCase(Cells(i, "c")) = "delete" Then EntireRow.Delete End If Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Macro with OR/ELSE condition | Excel Discussion (Misc queries) | |||
Delete Row with condition | Excel Discussion (Misc queries) | |||
Macro to delete rows based on a condition | Excel Worksheet Functions | |||
Can I delete an entire row if condition is not met? | Excel Worksheet Functions | |||
delete rows with certain condition | Excel Programming |