string size limitations for array formulas

  • Thread starter David Fazenbaker
  • Start date
D

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

Tom Ogilvy

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

Top