Hi, Im trying to copy a value from an array to a new array, ie., Array1(2, 1) = Array2(1, 1)
But this gives a subscript out of range error, the code is pretty basic.
Link to the file
But this gives a subscript out of range error, the code is pretty basic.
Link to the file
array.xlsm
drive.google.com
VBA Code:
Sub x1()
Dim Array1() As Variant
Dim Array2() As Variant
Array1 = Range("a1:a10").Value
Array1(2, 1) = Array2(1, 1)
End Sub