Anthony's VBA Forum

[simon]

I would like to know if arrays defined within a function can be passed to another function, modified, and then an array is returned back into the calling function.

The example I have in mind is that of passing a matrix and a column vector into a regression function, and then passing the resulting parameter vector back into the calling procedure.

I wish to do this without defining all the parameters outside of the function and hence accessible to every function in the module.

Any example code of how a similar process is carried out would be great!

thanks, Simon.