|
发表于 2013-9-11 16:59
|
显示全部楼层
本楼为最佳答案
本帖最后由 xdragon 于 2013-9-11 17:14 编辑
- Sub test()
- Dim arr(), brr()
- arr = Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row)
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- brr(i, 1) = Mid(arr(i, 1), 2)
- Next
- Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row) = brr
- End Sub
复制代码 |
|