![]() |
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