VBA Advanced Filter with And ,Or Criteria range

648 Views Asked by At

I am trying to set up an advanced filter with multiple criteria range ( And, Or operators ) the problem is when I run the code the results that appear are related to the last row in the criteria range while the previous rows are missing

According to the code Num refers to the last row in the criteria table (F to I)

If Sheet11.Range("P2,Q2,R2").Value <> Empty Then
Set AFCRange = Sheet1.Range("F3:I" & Num) 'Advanced Filter Criteria Range
Sheet13.Range("I1:A" & lastRow).CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=AFCRange, _
CopyToRange:=Sheet3.Range("K2:C2"), Unique:=False
End If

End With
0

There are 0 best solutions below