Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Like Autofilter

Hi,

I have some code that filters out anything like "Bulk Upload" and deletes the lines

   ActiveSheet.Range("A1:Q1").AutoFilter
     ActiveSheet.Range(Range("A1"), Range("C" & Rows.Count).End(xlUp)).AutoFilter Field:=3, _
        Criteria1:=Array("*Bulk Upload*"), Operator:=xlFilterValues

   ActiveSheet.Range(Range("C2"), Range("C" & Rows.Count).End(xlUp)).SpecialCells(xlVisible).EntireRow.Delete Shift:=xlUp
   ActiveSheet.Range("A1:Q1").AutoFilter

Open in new window


The problem is i have entries coming through that i need to keep - namely

"PCM ASP BB Clients Bulk Upload"

So all the other lines that contain Bulk Upload need to be deleted but the above needs to stay.

Can i say delete anything that is like "Bulk upload" except

"PCM ASP BB Clients Bulk Upload"


Many thanks!
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial