FormulaArray for formula more than 255 characters

[nileshvk]

Hi Guys,

I am trying to FormulaArray in my code and it does not work for formula having more than 255 characters. I have already tried couple of solutionas given on link below and this does not work for me

http://www.excelforum.com/excel-prog...ml#post3932754
Solution on this link does not work for formula with more than 255 characters

http://dailydoseofexcel.com/archives...comment-694109
Solution on this link gives me error: 'application-defined or object-defined '

here is my formula:

Worksheets("WorkSheet1").Range("B1:B12").FormulaArray = "=IF(ISERROR(MEDIAN(IF(WorkSheet!R2C4:R10000C4=R50C2,IF(WorkSheet!R2C7:R10000C7=R51C2,IF(WorkSheet!R2C12:R10000C12=RC1,IF(WorkSheet!R2C18:R10000C18=R2C17,WorkSheet!R2C13:R10000C13)))))),0,MEDIAN(IF(WorkSheet!R2C4:R10000C4=R50C2,IF(WorkSheet!R2C7:R10000C7=R51C2,IF(WorkSheet!R2C12:R10000C12=RC1,IF(WorkSheet!R2C18:R10000C18=R2C17,WorkSheet!R2C13:R10000C13))))))"

Any help in this is highly appreciated.....

Thanks,
-N

 

[ukmikeb]

Also posted here :-
http://www.excelforum.com/excel-pro...es-not-work-for-more-than-255-characters.html

Btw If you changed this line :-

.FormulaArray = "=IF(ISERROR(AAAA)),0,AAAA))"

to this :-

.FormulaArray = "=IF(ISERROR(AAAA),0,AAAA)"

your replace is quite likely to work bearing in mind Ricks comments in post #8.

hth

 

[nileshvk]

my bad, this code seems to be working for me