本帖最后由 26759761@qq.com 于 2015-2-2 22:09 编辑
- Sub x()
- On Error GoTo 10
- Range("m2:p" & Cells(Rows.Count, 1).End(3).Row).Clear
- Dim arr, ar(1 To 2000, 1 To 4), x As Integer, k As Integer
- arr = Range("a2:f" & Cells(Rows.Count, 1).End(3).Row)
- For x = 1 To UBound(arr)
- If arr(x, 2) > 0 Then
- k = k + 1
- ar(k, 1) = arr(x, 1)
- ar(k, 2) = arr(x, 2)
- ar(k, 3) = arr(x, 4)
- ar(k, 4) = "'" & arr(x, 6)
- End If
- Next
- Range("m2").Resize(k, 4) = ar
- Exit Sub
- 10
- End Sub
复制代码 |