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