Range.FormulaArray length problem

[ElieAintabi]

After trying extensively with http://www.dailydoseofexcel.com/archives/2005/01/10/entering-long-array-formulas-in-vba/ with no luck, I decided to repost with an updated version of the problem.

Let me explain, the solution in that post is fine, but it doesn't exaclty suit me because my FormulaArray is dynamic, being generated off userinput, so I am never away of exactly how many "parts" I will need, nor do I know where to SPLIT the equation into multiple parts.

So how can I assign my formula the FormulaArray property, or edit that technique to suit dynamic formulas.

 

[Colin Legg]

Probably best to stick with the original thread so everyone is working on the same page -

http://www.mrexcel.com/forum/showthread.php?t=366904