Write formula to cell using VBA

[Beemerang]

I am trying to write the formula below to a cell using VBA but I am receiving a 1004 error. Strangely, if I write exactly the same string to the cell as text (i.e. without the "=") and then manually insert the "=" it works perfectly!

Cells(x, 4).Formula = "=COUNTIF(Dic!$B$2:$B$2226;B" & x & ")+COUNTIF(Dic!$F$2:$F$2226;B" & x & ")"

Are there any characters that might need escaping or am I missing something else?

Cheers
Beem

 

[MARK858]

Try changing your ; to a , and see if that works for you in your locale.

Cells(x, 4).Formula = "=COUNTIF(Dic!$B$2:$B$2226,B" & x & ")+COUNTIF(Dic!$F$2:$F$2226,B" & x & ")"

 

[Beemerang]

Mark, thanks a million, that works. Weird though, because if I type a formula I have to use ";".

Thanks again though!

 

[MARK858]

Happy it worked for you. VBA is US based so thought it was worth a try, I just couldn't remember whether the worksheet would handle it which it why I termed it as I did.