|
问题出在代码4。好象数据量太大用transpose会出问题,把arr2,arr3改成二维数据就可以了。- Sub 代码04拆分市区()
- Dim s, x, arr, arr2(), arr3
- aa = Cells(Rows.Count, 1).End(3).Row
- arr = Range("F3:F" & aa)
- ReDim arr2(1 To UBound(arr), 1 To 1)
- ReDim arr3(1 To UBound(arr), 1 To 1)
- For x = 1 To UBound(arr)
- s = Split(arr(x, 1), " "): arr2(x, 1) = s(UBound(s))
- arr3(x, 1) = Left(arr(x, 1), InStrRev(arr(x, 1), " ") - 1)
- Next x
- Range("F3:F" & aa).ClearContents
- Range("F3").Resize(UBound(arr), 1) = arr2 'Application.Transpose(arr2)
- [c3].Resize(UBound(arr), 1) = arr3 'Application.Transpose(arr3)
- End Sub
复制代码 |
|