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 transform variables into range address | Excel Programming | |||
Efficiently transform variables into range address | Excel Programming | |||
Create Array From Values in range | Excel Programming | |||
How Can I copy all value of the array into the range? | Excel Programming |