I have an array formula that is 546 characters in length that I am trying to
place in a spreadsheet programmatically using the following syntax:

ActiveCell.FormulaArray = strFormula

But, this fails with the error: "Unable to set the formula array property of
the range class"

This method works with shorter formulas, is there a limit? If so, how do I
work around this?

Thanks in advance.