Runtime error 1004 when using .Formula

[trodneyrotter]

Hi - I'm trying to insert a formula using vba, which I thought would be fairly simple. The code I have used is:

Range("H573").Formula = "=IFERROR(IF(SUMIF(C_datadump!$B$23884:$B$24191,I_control!$F573,C_datadump!BG$23884:BG$24191)=1,1,0),"")"

However I am receiving runtime error 1004. I've been reading the existing forum posts about this and it seems the common problem is using ';' instead of ',' but I've not used semi-colon.

Another possible error maybe that its closing out too soon because of the "" at the end of the formula, but even when I remove these it still errors.

Grateful for any help you can give.

Thanks,

Ryan

 

[Michael M]

Whenever you use quotes in a formula in VBA they need to be doubled

Range("H573").Formula = "=IFERROR(IF(SUMIF(C_datadump!$B$23884:$B$24191,I_control!$F573,C_datadump!BG$23884:BG$24191)=1,1,0),"""")"

 

[Norie]

Try this.

Range("H573").Formula = "=IFERROR(IF(SUMIF(C_datadump!$B$23884:$B$24191,I_control!$F573,C_datadump!BG$23884:BG$24191)=1,1,0),"""")"

 

[trodneyrotter]

Excellent, that worked! Thank you very much for your help.