Selection.AutoFilter
ActiveSheet.Range("$A$5:$R$1800").AutoFilter Field:=1, Criteria1:="大五金"
ActiveSheet.Range("$A$5:$R$1800").AutoFilter Field:=17, Criteria1:=Array( _
"0.02", "0.12", "0.14", "0.19", "0.33", "0.48", "1.25", "2.14", "4.02", "5"), Operator _
:=xlFilterValues
解释一下VBA语句?
答案:1 悬赏:70 手机版
解决时间 2021-05-01 19:02
- 提问者网友:风月客
- 2021-05-01 06:39
最佳答案
- 五星知识达人网友:青灯有味
- 2021-05-01 07:18
选中的区域(一般是几列)进行筛选
在A列筛选“大五金”
在Q列筛选 "0.02", "0.12", "0.14", "0.19", "0.33", "0.48", "1.25", "2.14", "4.02", "5",每一个“,"是或的意思。
在A列筛选“大五金”
在Q列筛选 "0.02", "0.12", "0.14", "0.19", "0.33", "0.48", "1.25", "2.14", "4.02", "5",每一个“,"是或的意思。
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯