ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   efficiently copy values from a Range of cells to an array (in VB.N (https://www.excelbanter.com/excel-programming/302099-efficiently-copy-values-range-cells-array-vbulletin-n.html)

JW

efficiently copy values from a Range of cells to an array (in VB.N
 
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).


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com