|
发表于 2015-1-2 22:27
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim arr, i
- Dim brr(1 To 10000, 1 To 1)
- arr = Range("d7").CurrentRegion
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If arr(i, j) <> "" Then
- k = k + 1
- brr(k, 1) = arr(i, j)
- Exit For
- End If
- Next
- Next
- [d7].Resize(k) = brr
- End Sub
复制代码 |
|