|
- Sub 复制数据()
- Dim arr, i&, j&, brr, n&
- arr = [c1].CurrentRegion
- ReDim brr(1 To 10000, 1 To 1)
- For j = 1 To UBound(arr, 2)
- For i = 1 To UBound(arr)
- If arr(i, j) <> "" Then
- n = n + 1
- brr(n, 1) = arr(i, j)
- End If
- Next
- Next
- [a:a].Clear
- [a2].Resize(n, 1) = brr
- End Sub
复制代码 |
|