Insert formula in range of cells through VBA Code

[hrayani]

Hello Firends,

I am trying to insert the formula in the range of cells through a VBA code as below but it says that "Unable to set the formula array property of the range class" for the second formula. The first one works just fine. Can anyone please check & let me know what have I done wrong

This one works

ws.Range("AC2").FormulaArray = "=IFERROR(INDEX(fri_dpi_labtest_date,MATCH(1,($A2=fri_dpi_labtest_po)*(""FRI 2""=fri_dpi_labtest_category),0)),"""")"
ws.Range("AC2:AC2000").FillDown

But this does not

ws.Range("AC2").FormulaArray = "=IFERROR(IF(AB2=""Not Applicable"",""Not Applicable"",IF(INDEX(fri_dpi_labtest_quantity,MATCH(1,($A2=fri_dpi_labtest_po)*(""FRI 1""=fri_dpi_labtest_category),0))<L2*98%,INDEX(fri_dpi_labtest_date,MATCH(1,($A2=fri_dpi_labtest_po)*(""FRI 2""=fri_dpi_labtest_category),0)),""Not Applicable"")),"""")"
ws.Range("AC2:AC2000").FillDown

Regards,

Humayun

 

[RoryA]

Ah OK, I was talking about the length of the resulting formula, which won't have doubled quotes in it.

 

[hrayani]

Ah OK, I was talking about the length of the resulting formula, which won't have doubled quotes in it.

Yes

by the way If I enter the formula directly into the cell then it seems to be working just fine even though it has over 255 characters
so the restriction of entering a formula with over 255 characters is with VBA only... Am I correct ??

This is for my knowledge

 

[RoryA]

so the restriction of entering a formula with over 255 characters is with VBA only... Am I correct ??

Yes, that's correct.

 

[hrayani]

Yes, that's correct.

Thanks!