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 |
'[PA] 업무자동화 > [XL]Excel & VBA' 카테고리의 다른 글
| XL VBA kitchen utils (0) | 2022.05.10 |
|---|---|
| 색깔 있는 셀 개수 세기 (0) | 2022.04.08 |
| XL VBA Array (0) | 2022.02.26 |
| XL 모두 새로 고침 (0) | 2021.12.14 |
| XL Fill Down Blank Cells Until the Next Value in Excel (0) | 2021.12.03 |
