Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub DelRowsOnCond()
Dim LRow As Long ' 'How do I create a Range of rows to delete for Criteria1 Not Equal to "F1PPM60601" OR F1PPM60549" Etc... ' Range("a2").AutoFilter Field:=1, Criteria1:="<""F1PPM60601"",""F1PPM60549"",""F1PP M60623""" ' 'Exclude 1st row (Headers) With Sheets("Invoices") LRow = .Cells(Rows.Count, 1).End(xlUp).Row ' 'What is the right syntax to Delete Rows of the above defined Range .Range("A2:A" & LRow).Rows.Delete End With ActiveSheet.ShowAllData End Sub Help Appreciated, J.P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum specific column rows based on 2 different column criteria | Excel Worksheet Functions | |||
Delete Rows With Specific Text or Values | Excel Programming | |||
Delete rows if specific criteria not met. | Excel Worksheet Functions | |||
Delete rows that do not meet specific criteria | Excel Programming | |||
I want to delete certain rows based on specific criteria | Excel Programming |