Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
transferring matrix to range
A worksheet contains 10000 rows containing each 10 groups of (9 column of values PLUS 1 empty column). I want to define a range for each group and load them into an (integer matrix. After performing some calculations and changing some values o the a matrix I would like to write the array back into the range. Something like: ********* dim rngData as object dim arrValues(10000,9) as integer with worksheets("Sheet-1") set rngdata = range(.cells(1,1),.cells(10000,9)) arrValues = rngData.getvalues() 'a call like that but I don know the right one for i=1 to 10000 for j = 1 to 9 arrValues(i,j) = arrvalues(i,j) *rnd() '/// just SOM calculation next j next i rngdata.values = arrvalues ' a call like that but I don t know th right one end with ********* How can I read the values into the matrix and how can I store th values onto the range EFFICIENTLY -- JackRn ----------------------------------------------------------------------- JackRnl's Profile: http://www.excelforum.com/member.php...fo&userid=3717 View this thread: http://www.excelforum.com/showthread.php?threadid=56888 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
transferring matrix to range
You must use a VARIANT to a block of data from an excel range. (you can write any TYPED array to a range) There WERE limitations to the size of the array. Excel XP SP? and Excel 2003 dont have that limit any more. Dim vData as Variant vData =Range("a1:f10000").Value -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam JackRnl wrote in A worksheet contains 10000 rows containing each 10 groups of (9 columns of values PLUS 1 empty column). I want to define a range for each group and load them into an (integer) matrix. After performing some calculations and changing some values of the a matrix I would like to write the array back into the range. Something like: ********* dim rngData as object dim arrValues(10000,9) as integer with worksheets("Sheet-1") set rngdata = range(.cells(1,1),.cells(10000,9)) arrValues = rngData.getvalues() 'a call like that but I don t know the right one for i=1 to 10000 for j = 1 to 9 arrValues(i,j) = arrvalues(i,j) *rnd() '/// just SOME calculation next j next i rngdata.values = arrvalues ' a call like that but I don t know the right one end with ********* How can I read the values into the matrix and how can I store the values onto the range EFFICIENTLY? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing values within a matrix who are both in a column where theheaders are within a certain numerical range and in a row where the rowheaders are specified. | Excel Worksheet Functions | |||
Getting a position XY (range) on a matrix | Excel Discussion (Misc queries) | |||
Range Matrix | Excel Worksheet Functions | |||
transferring array to range | Excel Programming | |||
Transferring part of a multi-dimensional array to a range in VBA | Excel Programming |