The following snippet is supposed to (using that term lightly) create the ability to filter columns up to AO but it stops at AF.
My suspicion as to what could be causing this anomaly is that Column AF is the only column that has no data in it, so it stops there but I need the functionality to extend out to AO.
Thoughts?
VBA Code:
'Begins EVALUATE Items Removal that are also OOS
Selection.AutoFilter
With Range("A1:AO" & Range("A" & Rows.Count).End(xlUp).Row)
.AutoFilter Field:=41, Criteria1:="=EVALUATE"
.AutoFilter Field:=4, Criteria1:="=0"
.Offset(1).EntireRow.Delete
End With
ActiveSheet.AutoFilterMode = False
My suspicion as to what could be causing this anomaly is that Column AF is the only column that has no data in it, so it stops there but I need the functionality to extend out to AO.
Thoughts?