Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help / Question
I have a macro that deletes the entire row if it matches certain criteria.
What I need help with is I need to delete rows that DO NOT MATCH specfic criteria. Instead of "Like" I need a "not like" or similar. I want to delete the row if it does not contain 591119. T.I.A. Ed Sub DeleteRow2() Dim LastRow As Long Dim i As Long LastRow = Range("A6536").End(xlUp).Row For i = LastRow To 1 Step -1 If Range("S" & i).Value Like "VIP CHRG" Then Range("S" & i).EntireRow.Delete End If Next 'i For i = LastRow To 1 Step -1 If Range("S" & i).Value Like "EXCHANGE" Then Range("S" & i).EntireRow.Delete End If Next 'i End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help / Question
untested with yours but try
If not( Range("S" & i).Value Like "VIP CHRG") Then -- Don Guillett SalesAid Software "Ed" wrote in message ... I have a macro that deletes the entire row if it matches certain criteria. What I need help with is I need to delete rows that DO NOT MATCH specfic criteria. Instead of "Like" I need a "not like" or similar. I want to delete the row if it does not contain 591119. T.I.A. Ed Sub DeleteRow2() Dim LastRow As Long Dim i As Long LastRow = Range("A6536").End(xlUp).Row For i = LastRow To 1 Step -1 If Range("S" & i).Value Like "VIP CHRG" Then Range("S" & i).EntireRow.Delete End If Next 'i For i = LastRow To 1 Step -1 If Range("S" & i).Value Like "EXCHANGE" Then Range("S" & i).EntireRow.Delete End If Next 'i End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help / Question
Add NOT
If Not Range("S" & i).Value Like "VIP CHRG" Then If Not Range("S" & i).Value Like "EXCHANGE" Then --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help / Question
if instr(1,Range("S" & i).Text,"591119",vbTextCompare) = 0 then
Range("S" & i).entireRow.Delete End if -- Regards, Tom Ogilvy Ed wrote in message ... I have a macro that deletes the entire row if it matches certain criteria. What I need help with is I need to delete rows that DO NOT MATCH specfic criteria. Instead of "Like" I need a "not like" or similar. I want to delete the row if it does not contain 591119. T.I.A. Ed Sub DeleteRow2() Dim LastRow As Long Dim i As Long LastRow = Range("A6536").End(xlUp).Row For i = LastRow To 1 Step -1 If Range("S" & i).Value Like "VIP CHRG" Then Range("S" & i).EntireRow.Delete End If Next 'i For i = LastRow To 1 Step -1 If Range("S" & i).Value Like "EXCHANGE" Then Range("S" & i).EntireRow.Delete End If Next 'i End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro question | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions | |||
MACRO QUESTION | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions |