|
诶 本来想用数组的 不过智商不够 只能用循环这种慢速度的了 发给你看下 不过用用应该可以了
Sub djk()
Set Rng = Range("p2", Cells(Cells.Rows.Count, "u").End(xlUp)(2, 1))
Rng.Clear
Dim arr, a%, arr1, num%, num2%, k%, arr2
a = [a1].End(xlDown).Row
For i = 1 To a - 1
ReDim arr(1 To a, 1 To a)
arr = Range("g" & i + 1, "m" & i + 1)
arr1 = Application.Transpose(Application.Transpose(arr))
For Each ar In arr1
k = k + 1
If k <= 3 Then
If ar <> "" Then
num = num + 1
End If
Else
If ar <> "" Then
num2 = num2 + 1
End If
End If
Next
If num <> 0 And num2 = 0 Then
Range("a" & i + 1, "f" & i + 1).Copy Cells(Cells.Rows.Count, "p").End(xlUp)(2, 1)
End If
k = 0
num = 0
num2 = 0
Next
Rng.ClearFormats
End Sub
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
评分
-
查看全部评分
|