CODEWITHSUNDEEP
vbaexcel
Sebi
Sebi

Reputation: 3979

Adding formula via VBA throws Runtime-Exception

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?

Upvotes: 0

Views: 56

Answers (1)

Sebi
Sebi

Reputation: 3979

Need to use Comma instead of Semikolon.

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

Upvotes: 1

Related Questions