|
发表于 2014-4-2 22:43
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim arr, result()
- Dim lCount&, i&, j&
- arr = Range("a1").CurrentRegion
- If Not IsArray(arr) Then
- MsgBox "A1单元格区域数据不足"
- Exit Sub
- End If
- ReDim result(1 To (UBound(arr) - 1) * UBound(arr, 2), 1 To 1)
- For i = 1 To UBound(arr, 2)
- For j = 2 To UBound(arr)
- lCount = lCount + 1
- result(lCount, 1) = arr(j, i)
- Next
- Next
- Range("f2:f" & Rows.Count).ClearContents
- Range("f2").Resize(lCount).Value = result
- MsgBox "完成"
- End Sub
复制代码 |
|