|
发表于 2011-12-3 20:04
|
显示全部楼层
本楼为最佳答案
- Private Sub CommandButton1_Click()
- Dim arr1, arr2, brr(), I&, N&
- arr1 = Range("b7:d" & Range("b65536").End(3).Row)
- arr2 = Range("G7:I" & Range("G65536").End(3).Row)
- ReDim brr(1 To UBound(arr1) + UBound(arr2), 1 To 3)
- For I = 1 To UBound(arr1)
- If arr1(I, 1) <> "" Then
- N = N + 1
- brr(N, 1) = arr1(I, 1)
- brr(N, 2) = arr1(I, 2)
- brr(N, 3) = arr1(I, 3)
- End If
- Next I
- For I = 1 To UBound(arr2)
- If arr2(I, 1) <> "" Then
- N = N + 1
- brr(N, 1) = arr2(I, 1)
- brr(N, 2) = arr2(I, 2)
- brr(N, 3) = arr2(I, 3)
- End If
- Next I
- Range("g7:i100").ClearContents
- Range("g7").Resize(N, 3) = brr
- End Sub
复制代码 |
|