J
JW
Does anybody know how to efficiently copy (assign) values from a Range of cells into an VB(.NET) array variable (2d).
The other was is quite easy and well documented
(i.e. just do this: oSheet.Range("A1:C100").Value = DataArray
where DateArray is an array of 100*3)
The other way around seems more complicated though (and copying the values cell by cell is much too slow).
The other was is quite easy and well documented
(i.e. just do this: oSheet.Range("A1:C100").Value = DataArray
where DateArray is an array of 100*3)
The other way around seems more complicated though (and copying the values cell by cell is much too slow).