Application.ScreenUpdating = False
Rows.Hidden = False
Dim ar, x As Range, rng As Range
ar = Array("爱家", "微晶", "金属UV")
For Each x In Range([R1], [R65536].End(3))
If IsError(Application.Match(x, ar, 0)) Then
If rng Is Nothing Then Set rng = x Else Set rng = Union(rng, x)
End If
Next
If Not rng Is Nothing Then rng.EntireRow.Hidden = True
rng.CurrentRegion.EntireRow.Select
Selection.Copy
Sheets("自产门板").Activate
Range("A9").Select
Selection.Insert Shift:=xlUp
Application.ScreenUpdating = True
帮忙看看这个代码,把筛选隐藏的数据都给复制过去了,复制只复制筛选后可见单元格的的数据 |