vba - formularray not working

[jwoo89]

hi!

I am able to use the below formula in excel.

but when i run through VBA i get a runtime error.

Range("AM3").FormulaArray = "=IF(OR(AT3=""BAPUT"",AT3=""SECALL"",AT3=""OPT ASGNPUT""),(P3*100),IF(OR(AT3=""SEPUT"",AT3=""BACALL"",AT3=""OPT EXERPUT"",AT3=""OPT EXERCALL""),(P3*-100),IF(OR(AT3=""SA"",AT3=""BA"",AT3=""BAADR"",AT3=""BAVIX"",AT3=""BAB""),P3,P3*-1)))"


Can someone assist?

Would be greatly appreciated!!

 

[Fluff]

Just use .Formula as that is not an array formula

 

[jwoo89]

Thank you so much!! It worked!!

 

[Fluff]

You're welcome & thanks for the feedback.