I am trying to copy an array into another array.
I am using Excel 97 and writing a macro to do this. I have an array "NorthArray(100,19)" and I am trying to copy it to "TotalArray(100,19)".
The line I used was
NorthArray(100,19) = TotalArray(100,19)
This did not work
I have defined both of these
Dim NorthArray(100, 19) As String
Dim TotalArray(100, 19) As String
I am a novice at this, can anyone help.
Thanks
I am using Excel 97 and writing a macro to do this. I have an array "NorthArray(100,19)" and I am trying to copy it to "TotalArray(100,19)".
The line I used was
NorthArray(100,19) = TotalArray(100,19)
This did not work
I have defined both of these
Dim NorthArray(100, 19) As String
Dim TotalArray(100, 19) As String
I am a novice at this, can anyone help.
Thanks