|
发表于 2017-5-9 15:56
|
显示全部楼层
本楼为最佳答案
- Sub aaa()
- Dim arr, i&, n&
- arr = [l2:s60]
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If arr(i, j) <> "" Then n = n + 1
- Next j
- If n > 1 And n <= 4 Then [z65536].End(3).Offset(1).Resize(, UBound(arr, 2)) = Application.Index(arr, i)
- n = 0
- Next i
- End Sub
复制代码 |
评分
-
查看全部评分
|