string size limitations for array formulas

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?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array VLOOKUP lookup_Value does not increment 3
copying an array formula 2
populating cells with array bug? 4
Building a FormulaArray using VBA - Size Limit? 1
Array formulas cannot return strings longer than 255 1
array formula question 4
Format of Cell with Array Formula - Using VBA 2
FormulaArray problem 3

Top