I'm extracting data from a range into an array.
The range is 61 rows, 46 columns. My brute force
method is to use nested loops ...
For rr = 1 to 61
-- For cc = 1 to 46
----- aaData(rr, cc) = MySheet1.Cells(rr, cc)
-- Next cc
Next rr
This works, but it is a little slower than I'd like.
Is there a way to load the array in one fell swoop?