VBA macro Insert formula and then copy down 1004 application defined or object defined error

[colgert]

My excel file consists of 2 worksheets, "result" and "merchant2"
Trying to insert this formula in cell C1 of sheet "result" and then copy down:

=IFERROR(VLOOKUP(A1;merchant2.csv!$A$1:$B$1000;2;FALSE);"")

The formula works normally if I insert it manually, but if I want to do it through VBA (including the copy down in the code) I get error 1004 application defined or object defined error

I tried double quoting the quotes but same thing

I can see the line where formula is highlighted in yellow

Sub FillDown()

    Sheets("result").Range("C1:C" & LastRow).Formula = "=IFERROR(VLOOKUP(A1;merchant2!$A$1:$B$1000;2;FALSE);"""")"

End Sub

I know there are other posts about this but formulas vary and didn't want to hijack them with my question
Thank you for your help in advance.

 

[mole999]

which excel language are you in

 

[colgert]

my excel is in English, if that's what you are asking, thanks.

 

[colgert]

and it is not merchant2.csv in the formula, just merchant2, but I can't edit my post.
Also I read about the possibility of problems because of locked/protected cells, but it is not my case.

 

[mole999]

English usually uses , (comma) not (semi-colon) ;

post editing is controlled to 10 mins

 

[colgert]

yes, I thought so, but in fact if I use commas it doesn't work

 

[mole999]

you will have a different default set, thats a common issues when codes don't run.

1004 normally indicates something is missing, like a sheet name is spelt wrong

 

[colgert]

It has to be some syntax error when I put the formula in the vba code. That's what I really don't know.
The thing is, the formula works perfect (as it is now, with semi-colons and all) when inserted manually, and copied down manually, not giving any error about sheet names or anything.

 

[colgert]

Maybe somebody has an idea of what the problem can be... Thanks