Dear all,
I understand my previos post wasn't clear enough.
Hope this one is.
What i need to do is to writing all the values contained in myarray below to a1 in successive iterations to trigger s ome more formulas i have.
I was thinking of using x,y to identifying x-sm rows and y- sm columns but clearly made a mistake: code below.
Thanks for any assistance you can give, appreciate.
Regards, n
Sub Temp
Dim myarray As Variant
Myarray = worksheets("Sheet1").Range("b1:v50000")
For 1 to 1 e 6
Range("a1")= myarray(x,y)
Next
End Sub
Bookmarks