If I have an array defined like this:
how can I extract the contents of the 3rd row into cells A3:E3 without a loop, similarly to this:![]()
myMatrix = Range("A7:E100").Value
I know I can do this:![]()
Range("A3:E3").Value = myMatrix(3rd row of matrix)
for example so just looking to do the same thing but get the row out into a range of cells with just one shot vs. a single element into a single cell.![]()
Range("A3").Value = myMatrix(1,1)
Bookmarks