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