run time error '9' Subscript out of range

Question

hello,

i am trying to run a solver optimisation through vba 6 excel. but when the execution reaches the declaration of the objective function:

 Sheets(working).Range("B63").FormulaArray = _
        "=MMULT(MMULT(decision,covarMatrix),TRANSPOSE(decision))"

it gives the following message

"run time error '9' Subscript out of range"

how can i resolve this please?

Answer 1

It is impossible to determine a solution given the (limited) information provided.

Answer 2

Sheets(working).Range("B63").FormulaArray = _
  "=MMULT(MMULT(decision,covarMatrix),TRANSPOSE(decision))"

The solution:

Place Sheets("working") - not working - Hence solution as follows:

Sheets("working").Range("B63").FormulaArray = _
    "=MMULT(MMULT(decision,covarMatrix),TRANSPOSE(decision))"

Answer 3

what is this soulution ?? where we have to put this text ???