Set a cells Formula using VBA?

[rkcim]

How do you set a cells formula using VBA?

 

[Micr11]

Hi there,

I'm not quite used to blogs... yea I'm a little old! I am running in a problem with Excel Range.formula. Here is part of my code :

CODE_____________________________________________

TEMP_string = "=COUNTIF(" & .Range("DF_Donnees").Address & ";" & """<""" & "&" & AdresNivRel(.Range("DF_ClasMin").Offset(-Counter, 1).Address, 3) & ")"
.Range("DF_ClasMin").Offset(-Counter, 3).Formula = TEMP_string

ENDCODE____________________________________________

TEMP_String gives me exactly what I want "=COUNTIF("$A$37:$J$2007";"<"&"C15) but I get an error message #1004 error difined by application or object.... I am quite at a loss here. Any help would be great.

Rgds

 

[RoryA]

Replace the semicolons with commas in your formula string - VBA defaults to US regional settings.

PS This isn't a blog, but welcome to the forum.

 

[Micr11]

I'm good! I found it.... in french the delimiter for parameters is ";" and in english it's ","....