Hello all. Is there a way to import a range into a 2d array, without having to use a loop. Ive read that you can create an array from a range using
but Im not sure how to do that for just one row of a 2d array.
I have a 2D array with 2 rows and 10 columns. I want the first row (array(1,1) to array (1,10)) to be data from a workbook range. Then the second row will be data resulting from calculations done to row 1. I've tried using the above code to load the range into the array, but it only changes the value of array(1,10).
Code:
array=range("A1:A10").resize(1,10)
I have a 2D array with 2 rows and 10 columns. I want the first row (array(1,1) to array (1,10)) to be data from a workbook range. Then the second row will be data resulting from calculations done to row 1. I've tried using the above code to load the range into the array, but it only changes the value of array(1,10).