Hi

Define a Named Range, which contains all data you want to read into array
(it may be also a Dynamic Named Range) - let's it be p.e. MyNamedRange;
In VBA:

....
Dim arrMyArray() As Variant
....

Set arrMyArray = [MyNamedRange]
....


Arvi Laanemets



"michelle439731" wrote in message
...
Morning,

Please can you help me out with the following issue.
I want to apply a formula to a matrix in excel which will produce another
matrix of the same dimension.
I do not want to print this new matrix out onto a worksheet but manipulate
it first in VBA seperately.

I've tried the FormulaArray code :
Worksheets("Sheet1").Range("A1:C5").FormulaArray = fMyFunction(MyRange)
But you need to print the output onto a worksheet for it to work.

How can I keep everything internal?

Thank you!

Michelle