精简点的:
Sub wayy()Dim i As IntegerFor i = 1 To 10 Selection.autofilter Field:=i, Criteria1:="<>" & Cells(1, i), Operator:=xlAndNextEnd Sub
使用道具 举报
非常谢谢楼上,精简的正是我想要的,还有一个问题请教一下:
如果有不连续的几列怎么办呢?比如:For i = 1 To 10,另外一组是For i = 22 To 35
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-6-6 05:39 , Processed in 0.634193 second(s), 7 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.