Autofilter with delete entire row

[DexterX]

Hello,

I've been muddling through solving this problem but have got stuck now, goal is to use autofilter to identify rows that do not contain value 1 or value 2 in column c and then delete those rows thus leaving me with only rows containing value 1 or 2

Dim rngTemp As Range


Set rngTemp = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
If Not rngTemp Is Nothing Then
Range(Cells(1, 1), rngTemp).Select
.AutoFilter Field:=3, Criteria1:=Array("*UK*", "*02*"), Operator:=xlFilterValues
End If


After row Range(Cells(1, 1), rngTemp).Select . My selected range is good and I can see it in the worksheet, but I cant figure out my next step as the following line will not compile

Any help much appreciated

Dex

[Kenneth Hobson]

The better tool is AdvancedFilter. If you need help to see how the criterion are setup, see:
https://support.office.com/en-us/art...8-3f16abdff32b
http://www.contextures.com/xladvfilter01.html

I do have a concern about your *01*. If that is for text values like A01X, that is ok. If it is for a number value of 1 number formatted to 01, then that would not be ok. In that case, you will need to convert the column of values to the TEXT value and not VALUE property.