Adding formula via VBA throws Runtime-Exception

Question

I am trying to add a formula to a cell via VBA but just getting Runtime-Exception 1004 without further information.

Cells(4, 3).Formula = "=IF('Mustermann, Max'!C13="""";"""";""impacting team targets"")"

Is there something wrong with my formula?

Sebi · Accepted Answer · 2015-11-23 07:16:21Z

1

Need to use Comma instead of Semikolon.

Cells(4, 3).Formula = "=IF('Mustermann, Max'!C13="""","""",""impacting team targets"")"

answered Nov 23, 2015 at 7:16

Sebi

3,9792 gold badges39 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1