string size limitations for array formulas

[David Fazenbaker]

From scanning previous posts, it seems that any VBA code using .FormulaArray
to take a string and use it to put an array formula into a cell is limited to
a string size of 255 characters.

if I use VBA code similar to the following...

answer = Evaluate("some array formula string here")
Sheet1.Range("D1") = answer

am I restricted by the same string size limitation?

 

[Tom Ogilvy]

Think of Evaluate or [] as being a virtual cell - so you would have the same
limitations.