Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm having trouble with this code:
Sub RowDelete() Dim i As Long Dim iLastRow As Long iLastRow = Cells(Rows.Count, "A").End(xlUp).Row For i = iLastRow To 2 Step -1 If Cells(i, "D").Value < "MN*" Or Cells(i, "D").Value < "MP107*" Then Rows(i).Delete End If Next i End Sub I'm trying to delete all rows where the text contained in column D DOES NOT equal MN or MP107. When I run this procedure, it deletes ALL rows. Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
#Ref! after row deletion | Excel Discussion (Misc queries) | |||
name deletion | Excel Discussion (Misc queries) | |||
Conditional deletion of cell contents | Excel Worksheet Functions | |||
Problem with Conditional format deletion | Excel Discussion (Misc queries) | |||
Row Deletion | Excel Programming |