Unable to set the FormulaArray Property of the Range Class?

[stockgoblin42]

Hi, I just did a Record Macro and Excel doesn't like this part of the code:

Please Login or Register  to view this content.

What does Unable to set the FormulaArray Property of the Range Class? mean and can you see why.

I tried just going into the code and replacing the formulae with the actual ones:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

but it doesn't like that either.

What is going on?

Is there a better way to Macro some array formulae?

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.