expected list separator or ) error

[akkinarula]

Hi all
i m trying to write counif function which count rows of sheet2's one of the column using criteria of sheet3's column2 (which is merged,their column names are 'B' and 'C' and row no is 10)
i've tried following thing but it gives me expected list separator or ) error

and also i have specified merged cell as c2 only(originally it is combination of c2&c3) is it right to specify this way.


ActiveCell.FormulaR1C1 = _
"=COUNTIF('Customer''s Details'!R13C39:R262C39,'RCL Mix'!R" & Trim(Str(i)& "C2)"

i m using dynamic row no using i as variable whose value is put by for loop.
i m using excel 2003
plz help me to solve this problem

 

[mikerickson]

Perhaps
"=COUNTIF('Customer''s Details'!R13C39:R262C39,'RCL Mix'!R" & Trim(str(i)) & "C2)"

 

[akkinarula]

Perhaps
"=COUNTIF('Customer''s Details'!R13C39:R262C39,'RCL Mix'!R" & Trim(str(i)) & "C2)"

i m writting macro so i have to write activecell.formular1c1

 

[mikerickson]

The there were some changes in the string I posted, a space before an ampersand and a parenthesis were added, does replacing the string in the posted code with what I posted do what you want?

 

[akkinarula]

The there were some changes in the string I posted, a space before an ampersand and a parenthesis were added, does replacing the string in the posted code with what I posted do what you want?

thanks mikerickson