View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Issue with arrays

You can pass the variable to a SUB using BYREF


Sub Main()

Dim a(10)
For i = 0 To 9
a(i) = i
Next i
Call arraya(a)

End Sub
Sub arraya(ByRef a As Variant)


Call arrayb(a)


End Sub
Sub arrayb(ByRef arraya As Variant)

arraya(5) = 100

End Sub



"johnmasvou" wrote:

I have two functions.

Function A should return a matrix array (mxm) and at some point it calls
function B which has one agrument, a vector array (1xm). The output of
function B should be a vector array (1xm).

Using (probably) a loop, how can I assign each time the output of B as one
row on the matrix of function A?

Something like A(i,)=B(Zi) would work in other languages but what about in VB?

thx