Long Array Formula VBA

**maacmaac** · 12-26-2011, 05:08 PM

I have a formula in cell Q2 as follows

Please Login or Register  to view this content.

I am trying to use this formula in VBA. I have tried

Please Login or Register  to view this content.

I have also tried

Please Login or Register  to view this content.

.

I can't get either of these methods to work. I believe there is a 256 char limit for array formulas in VBA, which would explain why the first method won't work. Is there any workaround that might work? Thanks.

**DonkeyOte** · 12-26-2011, 06:06 PM

Could you perhaps shorten the Array along the lines of:

Please Login or Register  to view this content.

Given only the row increments you need only hardwire starting row in appropriate range references I think...

**maacmaac** · 12-27-2011, 08:57 AM

DonkeyOte,

This works just like the long code and works in VBA. However, I am not coming up with the expected results. This refers back to thread 807004 http://www.excelforum.com/excel-prog...html?p=2670272

Thanks again for your comments.