Problem in COUNTIFS statement

Hi,

I am creating a macro, in that i am using COUNTIFS function like below

Activecell.FormulaR1C1= "=COUNTIFS(C:C,A" &ik &")"

ik = 1 to 10

In the cell it appear as =COUNTIFS(C:C,'A1') instead of =COUNTIFS(C:C,A1). So I am getting error. The apostrophe should not appear.

Any help would be greatly appreciated.

Thanks
Abdul

Hi, Abndul,

change the way the formula is put into the cell from R1C1 to A1 like

ActiveCell.Formula = "=COUNTIFS(C:C,A" & ik & ")"

Ciao,
Holger