|
发表于 2013-3-29 10:03
|
显示全部楼层
本楼为最佳答案
- Sub 复制()
- Dim arr, brr()
- arr = Range("a1").CurrentRegion
- Dim i As Long, l As Long, k As Long
- If Not IsArray(arr) Then MsgBox "数据不足": Exit Sub
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = LBound(arr) + 1 To UBound(arr)
- If arr(i, 1) Like "*多品*" Then
- l = l + 1
- brr(l, 1) = arr(i, 1)
- For k = LBound(arr, 2) + 1 To UBound(arr, 2)
- brr(l, k) = arr(i, k) * -1
- Next
- End If
- Next
- Range("h1").Resize(, UBound(arr, 2)) = WorksheetFunction.Index(arr, 1, 0)
- Range("h2").Resize(l, UBound(brr, 2)) = brr
- End Sub
复制代码 |
|