Hy everybody,

I get the error 1004 : application-defined or object-defined error

my script is :

...
Dim i As Integer
Dim x As Integer
i=1
x=i+9
...

ActiveCell.FormulaR1C1 = "=COUNTIFS(C[x] ,""=""&R2C8,C[11],""<>0"")"

...








C[11] is accepted but not the C[x] even though x has been defined as integer...

Someone to help me ?

Thankx

Daniel