Insert Excel Formula via VBA

0
votes

as a continuation from another question, I'm trying to solve my problems inserting a formula via VBA on a macro.

Here's my code:

Range("F1").Select
ActiveCell.Formula = "=IF(C1=""LPPD"";""MIPRU"";IF(C1=""LPGR"";""DCT"";IF(OR(C1=""LPFL"";C1=""LPCR"");""LADOX"";IF(OR(C1=""LPPI"";C1=""LPSJ"";C1=""LPHR"");""NOTMA"";""ERRO""))))"

For some reason, and the code doesn't show any errors, when I try to run it I get:

Run-time error ("Application-defined or object-defined error")

Worth mentioning I'm using Excel 2003.

Hope I'll be able to find my answer with you guys! Thanks in advance.

1
vbaexcel

1 Answers

2
votes

VBA is US-EN centric, so using the .Formula the formulas must be with , instead of ;:

Range("F1").Formula = "=IF(C1=""LPPD"",""MIPRU"",IF(C1=""LPGR"",""DCT"",IF(OR(C1=""LPFL"",C1=""LPCR""),""LADOX"",IF(OR(C1=""LPPI"",C1=""LPSJ"",C1=""LPHR""),""NOTMA"",""ERRO""))))"

Or you can use .FormulaLocal

Range("F1").FormulaLocal = "=IF(C1=""LPPD"";""MIPRU"";IF(C1=""LPGR"";""DCT"";IF(OR(C1=""LPFL"";C1=""LPCR"");""LADOX"";IF(OR(C1=""LPPI"";C1=""LPSJ"";C1=""LPHR"");""NOTMA"";""ERRO""))))"