View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Adrian T[_2_] Adrian T[_2_] is offline
external usenet poster
 
Posts: 11
Default Multidimensional Array

Hi:

Wouldn't it make any faster? If you think it wouldn't, let
me know and I'll be satisfied.

I did the similar thing with the whole array. My code
follows:

Dim arrSumActPeriodicClaims(15,5) as variant

Range("Sum_ActualPeriodicClaims").Cells(2, 2).Resize(15,
5).Value = arrSumActPeriodicClaims

I wanted to figure out how to do the similar for only one
column vector. What I have now is with loop.

intIteration = 3 '--The 3rd column vector

For i = 1 To 15
Range("Graph1_ActualPeriodicClaims").Cells(1, i + 3).Value
= arrSumActPeriodicClaims(i, intIteration)
Next i



Regards,
Adrian T




-----Original Message-----
Why do you want to do it without recursion, and can you

paste the code
you are currently using?


---
Message posted from http://www.ExcelForum.com/

.