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

Range("K24").FormulaArray = "=Max(if(A1:A10=5,B1:B10))"

Yes, I believe the string can't be more than about 255 characters when using
FormulaArray.

--
Regards,
Tom Ogilvy


"PCLIVE" wrote:

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