Matrix manipulation in VBA without printing out the worksheet
in this demo, matrix1 is loaded from a spreadsheet, then that matrix is
inverted and saved into natrix2
Option Explicit
Sub MatrixManipulation()
Dim matrix1 As Variant
Dim matrix2 As Variant
matrix1 = Range("B6:D8")
matrix2 = WorksheetFunction.MInverse(matrix1)
' do something with matrix2
End Sub
you should step (using F8) througj to the end sub then view both matrices in
the watch window to see their contents
"michelle439731" wrote:
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
|