View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JW JW is offline
external usenet poster
 
Posts: 22
Default 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).