我想将所选行的值存储在一个动态的二维数组中。
Dim values() As Variant
values=ActiveCell.EntireRow.Select
我是VBA.I的新手,我有行和列的数据,我想将特定选定行的所有值存储在一个数组中,然后计划进一步使用这些值。
发布于 2018-07-05 03:40:37
下面这样的代码应该能起到作用:
Sub Test()
Dim COL As Long, X As Long, Y As Long
Dim MyArray() As Variant
COL = Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Column
For X = 1 To COL
ReDim Preserve MyArray(Y)
MyArray(Y) = Cells(ActiveCell.Row, X).Value
Y = Y + 1
Next X
For X = LBound(MyArray) To UBound(MyArray)
Debug.Print MyArray(X)
Next X
End Sub
https://stackoverflow.com/questions/51179384
复制相似问题