Syntax of integer object in relative column position

[Daniell]

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

[:) Sixthsense :)]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[Norie]

Daniel

Can you post the formula you are trying to enter?

PS When posting code pleasr use code tags.

[Daniell]

Ok sorry,

Let see :

Please Login or Register  to view this content.