VBA Array Subset Assignment

[Tom Neville]

Is there a way to specify a "range" of "cells" in a VBA array that allows the following actions:

I am working with large 2D arrays. I would like to assign part of the array to a Range and assign a Range to part of an array. For a simple example, I would like to select a row "record" from the data in a 2D array and assign it to a Range as a row "record" on a worksheet. Alternatively, I would like repeatedly to select a Range that is a row "record" on a worksheet and assign it to the next "row" in a large array.

I have not been able find documentation that shows how to specify a "range" in an array, other than cell by cell - MyArray(i,j)=Cells(k,l).

Thanks

 

[wigi]

Indeed, you will have to loop cell by cell. But in memory working with arrays is usually very very fast.

For reading from and writing to the sheet, read and write in 1 operation, not cell by cell.

 

[Tom Neville]

wigi,

Thanks! I was hoping for a cleaner solution but understand what I need to do.

Tom