|
5学分
我想在VBA中实现截取某列单元格的第9位到第13位
vba.mid(range("a1:a1000"),9,4)
请问可以用列或着数组做mid的参数吗,谢谢高手指点!
- Private Sub CommandButton1_Click()
- Dim arr, arr2, t
- Dim i As Long
- t = Timer
- arr = Range("A1", [A65536].End(xlUp))
- ReDim arr2(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- arr2(i, 1) = Mid(arr(i, 1), 9, 4)
- Next
- [B1].Resize(i - 1, 1) = arr2
- MsgBox Timer - t
- End Sub
复制代码我的电脑在数据2万条的时候运行时间是0.047秒。
|
|