Is there a size limit or character lenght restriction when trying to apply a
FormulaArray using VBA? I have this Array formula that I can apply manually
using Ctrl-Shift-Enter. That works fine. However, I can build that array
formula using VBA. I've tried recording a macro and enter the cell with the
formula and just pressing Ctrl-Shift-Enter. I get a message saying it can't
record. Keep in mind that I can apply the same text in the array formula
using:

Range("K24").Formula "{=my formula text}

However, obviously that will not create an array formula.

Any ideas.
Thanks,
Paul