string size limitations for array formulas
 

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?

string size limitations for array formulas
 

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

--
Regards,
Tom Ogilvy


"David Fazenbaker" wrote:

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?