string size limitations for array formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Think of Evaluate or [] as being a virtual cell - so you would have the same
limitations.
 
Back
Top