XL VBA Filter Auto, Advanced

20220303 2036 

 

REF

[1] "https://docs.microsoft.com/en-us/office/vba/api/excel.range.autofilter"

[2] "https://docs.microsoft.com/en-us/office/vba/api/excel.range.advancedfilter"

 

auto filter

ActiveSheet.UsedRange.AutoFilter Field:=2, Criteria1:="20"

 

advanced filter

Range("A1:D5").AdvancedFilter Action:=xlFilterCopy, _                               CriteriaRange:=Range("F2:F3"), _                               CopyToRange:=Range("A9"), Unique:=False