VBa有一个数组A,含有数值2,3,6,8,9,12,14,19,插入一个数值10
1,假设数组从1开始,
2,把原来数组元素输出
3,可选择数组位置插入一个数10
4,把插入一个数后的数组元素输出
- Sub 插入元素()
- Dim A, B&, C, W%, i%, s$
- A = [{2,3,6,8,9,12,14,19}]
- C = A
- B = 10 '插入元素
- W = 5 '指定位置,任意指定
- ReDim Preserve A(UBound(A))
- For i = UBound(A) To W Step -1
- A(i) = A(i - 1)
- Next
- A(i) = B
- MsgBox "数组元素列表:" & vbCrLf & Join(C) & vbCrLf & "所要插入的元素为:" _
- & B & vbCrLf & "插入位置:" & W & vbCrLf & "插入后数组:" & vbCrLf & Join(A)
- End Sub
复制代码
|