Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi Lift Off
this sub keeps the rows with non values in M/N and values in M/N if not this help, twist it around. Sub ss() Sheets("ppp").Select Dim i As Double i = Cells(Rows.Count, 1).End(xlUp).Row For i = i To 6 Step -1 If Range("M" & i) "" And Range("N" & i) <= "" _ Or Range("N" & i) "" And Range("M" & i) <= "" Then ' do nothing Else Range("M" & i).EntireRow.Delete End If Next i End Sub regards yngve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting rows meeting certain criteria in a particular column | Excel Discussion (Misc queries) | |||
Deleting several rows with given criteria | Excel Discussion (Misc queries) | |||
deleting multiple rows with multiple criteria | Excel Programming | |||
Deleting rows based on multiple criteria | Excel Programming | |||
Cut rows from one sheet into multiple sheets based on a criteria in first column | Excel Programming |