| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking multiple cells efficiently | Links and Linking in Excel | |||
| efficiently copy values from a Range of cells to an array (in VB.N | Excel Programming | |||
| Efficiently transform variables into range address | Excel Programming | |||
| Efficiently transform variables into range address | Excel Programming | |||
| How Can I copy all value of the array into the range? | Excel Programming | |||
Linear Mode
