AutoFilter1 [VBA] 자동 필터 (.AutoFilter) #VBA #필터 #AutoFilter 1. VBA 코드 1 2 3 4 5 6 7 8 9 10 11 Sub 자동필터() Sheets("data").Range("A1").AutoFilter field:=2, Criteria1:="사과", Operator:=xlOr, Criteria2:="복숭아" Sheets("data").Range("A1").CurrentRegion.Copy Sheets("Report1").Range("A1") Sheets("data").Range("A1").AutoFilter Sheets("data").Range("A1").AutoFilter field:=4, Criteria1:=">=100", Operator:=xlAnd, Criteria2:="=100", Operator:=xlAnd,.. 2023. 8. 13. 이전 1 다음
